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]))
     
Anonymous's avatar
Anonymous
Not applicable
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]))