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]))
     
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

I cannot view your pic as you shared. Could you please share your sample data and excepted result again? You can upload your files to onedrive and share the link here.

 

Regards,

Frank