Filter out all zero value for an ALL measure.

[BasedBjorn]

Hi,

Fairly new to DAX, but will try to explain my issue the best I can.

I have a "total sales" measure, and another "total sales ALL" measure with a few ALL statements. I did this so I can compare sales location results vs all store locations. My pivot also includes category and brand. These columns are included in my ALL statements in my "Total Sales ALL" measure. I am looking to adjust my "total sales ALL' measure to only include results where my "total sales" measure does not result in zero. Please see below. I would like the Total Sales All to result in 18 if that makes more sense as seen in below image.

https://ibb.co/geAjia

Thanks!

 

[olofmur]

Something like

total sales ALL:=CALCULATE(SUM(total sales);FILTER(salestable, total sales<>0))