Getting Category total per Item

[sparkplug93751]

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 = 

CALCULATE(SUMX(Category,[Forecast Cost]),

(GROUPBY(Category,Category[Category])),

USERELATIONSHIP('Forecast'[Category & Description],'Category'[Category & Description]))

It's not summing the values rather performing the forecast cost which is 

Forecast Cost = (Planned items * cost per item)+cost so far

Any help is appreciated

[Anonymous]

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.

[sparkplug93751]

The 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

https://tuprd-my.sharepoint.com/:x:/g/personal/tug67925_temple_edu/Ea-YR9LgqXtKhvpCz5fAJqABxrYlIiGLX... 

[Greg_Deckler]

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