Forum Discussion
Solved
Aggregation 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]))...
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.
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.
That's great! The solution I was looking for! I appreciate your help 🙂