Forum Discussion
Ritaf
Responsive Resident
3 years agoAggregation for category which doesn't appear at visual
Hi there, I am trying to calculate the sum by category as I won't use this category in my visual, so I can't do it with : Test= CALCULATE( sum('Table'[score]),ALLEXCEPT(table,'table'[abc_item_ID]))...
- 3 years ago
Hi Ritaf1983 ,
try this measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mangaus1111
Solution Sage
3 years agoHi Ritaf ,
see my pbi file. Let me know if the link does not work.
https://1drv.ms/u/s!Aj45jbu0mDVJiyMYU1Vqkgf7UrWI?e=SlISVu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.