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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Ritaf ,

 

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
SUMMARIZE('Table',[CusOrder],[PORDER],[Customer],[CatalogID],"TotalUnitsPurchased",
SUMX(FILTER(ALL('Table'),'Table'[CatalogID]=EARLIER('Table'[CatalogID])),[POuniysQuantity]))

2. Result:

If you need pbix, please click here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Thanks for your assistance.
Are you sure that your solution is better than the calculated column I created: 

QTYbyCorder = sumx(filter('factOrdersPurchase',factOrdersPurchase[OrdersCustomerItemId]=EARLIER(factOrdersPurchase[OrdersCustomerItemId])),'factOrdersPurchase'[QTY])