Forum Discussion
I can't filter zero
Super UserHi CarlesWRC ,
What about a dax formula like below? I've manually recreated your PBI screen print and it seems to produce your required output.
I attach the link to the pbix file below:
Thank you very much! It works perfectly. I just changed the 'SE_PBI_GRPZ_SEGM_MARCA'[PVP TY]' by the metric [PVP TY]. The only thing that it seems to not work is the Total. I would expect that the total should show the sum of each time where the sum by reference is greater than 20. But what I get is the count of all distinct references.
I have this:
For example, if I have 111 different references, but only 3 match the logic of greater than 20, so the total should be 3 and not 111...
Thank you in advance!
I don't have a lot of experience and I'm having trouble with this part of the report.
Greetings.
- DataNinja777
Hi CarlesWRC ,
If you'd like the total of your measure to add up correctly, please use sumx in a measure over the table which you want the aggregation to work like below:
I attach the link to the updated pbix file below with the above measure:
Hi!
I tried to use SUMX but I don't get what we would expect:
I really don't understand what is happening. Something I'm doing wrong, because this kind of stuff is pretty easy to do in other BI tools..
Thanks for your help!