Forum Discussion

CarlesWRC's avatar
CarlesWRC
New Member
3 years ago

I can't filter zero

Hi All!   I'm trying to make something pretty easy, but I'm going crazy right now because I really don't understand how to solve this. I made similar stuff like that and is the first time that I ge...
DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
3 years ago

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:

ENTRADAS KPI 20.pbix

 

 

 

CarlesWRC's avatar
CarlesWRC
New Member
2 years ago

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!