Forum Discussion
Helper IIGetting Category total per Item
Hello,
I have a measure that I want to use to measure where (actual item/category total)*forecast total = item forecast
How can I isolated the category total for it to be the same per item in the category? I'm currently using a sumx but that isn't adding the values, only aggregating it at a higher level where
Category total =
3 Replies
- Greg_Deckler
Community Champion
Tough to follow, sample data and expected output would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi sparkplug93751 ,
Sounds like you can use ALLEXCEPT() function.
Something like
calculate(sum(value),allexcept(table,category))Better to share some sample data to us so that we can offer more detailed help.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sparkplug93751The hours column is a calculated measure in my matrix and appears without issue. THe measure I need to show now is the total per category next to each task. ie category A is 60.
Since the hours column is a measure using a ratio (mentioned in first post), power bi isn't summing the category, rather applying the function to it - even when using sumx
Thanks
