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 , could you please send us a sample table and your expected result?
Hello,
I have attached a picture of the data and the expected result.
For every OrdersCustomerItemId, I need to calculate the sum of POunitsQuantity without using OrdersCustomerItemId in the visual.
Right now I am using a calculated column with an earlier function, and I am wondering if there is a better way to accomplish this.
Thank you, Rita