2 Replies Latest reply on Jul 27, 2018 3:02 PM by Tina Crouse

    Exclude an item in a dimension if the measures are null

    Tina Crouse

      I have a dashboard I have built where I have 2 tables and then 1 graph. The first two tables show the prior month versus the current month by state. The 2nd in the DB shows the change whether positive or negative. The 3rd is a rolling 13 month graph.

       

      I have a filter for my vendors. I have 7 vendors in all. Everything lines up perfectly until I hit one of the vendors and then my graph does not line up and I see it is because the vendor has prior and current month data for 2 of the 4 measures so the graph cannot computer and does not line up. How can I exclude the single market when I select this vendor. Is there some calculation I can write that says if the measures are null exclude the market?