Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Null values in calculated measure in matrix visual

Hello everyone,   I have created a matrix visual wit a dimension in rows (Store), a dimension in columns (Product) and with a calculated measure as Value (Measure1).      I need to show on...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Finally, I solved the issue changing the second condition of the IF in the measure, like this:

    Measure = 
    	IF( 
    	  CALCULATE(
    	    DISTINCTCOUNT(Table1[Product]);
    	    ALLSELECTED(Table1[Product])
    	  ) 
    	= 
    	  CALCULATE( 
    	    DISTINCTCOUNT(Table1[Product]);
    	    ALLSELECTED(Table1[Product]);
    	    ALLSELECTED(Table1[Store])
    	  ); 
    	SUM(Table1[Units]))
     
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Can you put your Measure in a Visual Filter and filter out the values that way?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Greg_Deckler,

     

    Thanks for your answer but it doesn't work.

     

    When I filter the measure by "is not blank" I get exactly the same results because there are non blank values at least for one product of each row of the matrix.

     

    When I filter by "is greater than 0" I also get the same rows, because there is at least one value greater than 0 in the row.