Forum Discussion
Helper VExclude 0 values from a subtotal in a Matrix
It's becuase the VAR amounts are smaller than .01, in the grid they show 0 because of the format but if you change the VAR format to something with say 5 decimal places you can see it:
If you change your Var. measure to the following it should work better for you:
VAR. = ROUND([EDWF]-[Fusion],2)
Also, you don't have to (and shouldn't) put the table name in your formula when referencing a measure. That way, when you are looking at a formula you know 'Brand Fusion & EDWF Data'[Value] is a column in a table and [EDWF] is a measure.
Super UserWhat if you add into the filter
AND
is not
BLANK()
?
Helper VThanks for the quick response. No change unfortunately.
- jdbuchanan71
Is it maybe that the visual just isn't refreshing? I made a sample model to test and am getting the behavior you are looking for. First image is unfiltered, second is filtered on VAR measure only.
No filterVAR filter
- imranamikhan
I have run a full refresh but unfortunately that has not resolved the issue either. May I send you my working file?
- jdbuchanan71
Certainly, if you post it to a dropbox or onedrive I can look at it.