Hide measure in matrix if no sales in current month

[EmmyAmsterdam88]

Hi all,

I was wondering if someone has the answer to the following.

I am trying to make a matrix with monthly figures as per underneath, including delta: unitmargin - minimum cost. Since this cost is set static for all months, it shows also for accounts with no volume a delta. However i would like to hide the Delta measure if no volume is sold in the specific month.  

Can anybody help on how to do this with dax or another functionality?

Thank you,

Emmy

[daXtreme · Accepted solution]

In your measure check if there's any data for the volume. You can use many functions to do that. One would be ISEMPTY. This is the fastest way but if you can't use it for some reason, then just check if the base measure does not return blank. If not, then return what you need, else - return blank.