Forum Discussion

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
3 years ago
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]))...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mangaus1111's avatar
    mangaus1111
    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's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

Hi , could you please send us a sample table and your expected result?

Ritaf's avatar
Ritaf
Icon for Responsive Resident rankResponsive Resident
3 years ago

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