Forum Discussion
Ritaf
Responsive Resident
Responsive ResidentAggregation 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.
Ritaf1983
Super User
Super UserThanks 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])
Since this measure is one of many in this report, I don't need another table. However, I know that earlier is a very wasteful function, so I wondered if there was a way to calculate it with a measure using a virtual table.
Since this measure is one of many in this report, I don't need another table. However, I know that earlier is a very wasteful function, so I wondered if there was a way to calculate it with a measure using a virtual table.
mangaus1111
Solution Sage
Solution SageHi 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.
- Ritaf
That's great! The solution I was looking for! I appreciate your help 🙂
