Forum Discussion

alexpantex's avatar
alexpantex
Frequent Visitor
2 years ago

Calculate share contribution

Hi everyone,   I'm trying to solve one problem I have, but with no success.   I'm havig matrix visual with this simplified structure (total is not part of the fact table, it's automatically calcu...
Need Help
v-weiyan1-msft's avatar
v-weiyan1-msft
Icon for Community Support rankCommunity Support
2 years ago

Hi alexpantex ,

 

Based on the sample and description you provided, Please try code as below to create two measures.

 

Total_Value = CALCULATE(SUM('Fact Data'[Value]), ALL('Fact Data'))
Contribution = DIVIDE([Value_Category],[Total_Value])

 

Result is as below.

 

Best Regards,

Yulia Yan

 

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