Forum Discussion
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...
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.
Hi Yulia,
Thanks for the reply.
This approach doesn't help since as I mentioned there are other dropdowns like country, time period, category, subcategory that are used to filter data, so using ALL() would evaluate it on entire dataset, instead on that subset.