Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
As you can see I have a table with these data:
Share of Voice has been calculated as:
What I would like to have is a mesure that calculate correctly the percentage on column added, so sum of Spend over sum of Category by each level of granularity.
Ex. In Table 1:
2022 | 1 | 1010 | 2816 | 36%
Ex. In Table 2:
2022 | 6596 | 77913 | 8,4%
Could you please help me?
Thanks
Solved! Go to Solution.
Try these measures. Percentages need to be calculated in a measure, not a column in the table; this allows them to dynamically calculate in the filter context of the visual.
Sum of Spend = SUM ( Spend[Spend] )
Sum of Total Category Spend = SUM ( Spend[Total Category Spend] )
Share of Voice = DIVIDE ( [Sum of Spend], [Sum of Total Category Spend] )
Proud to be a Super User!
Try these measures. Percentages need to be calculated in a measure, not a column in the table; this allows them to dynamically calculate in the filter context of the visual.
Sum of Spend = SUM ( Spend[Spend] )
Sum of Total Category Spend = SUM ( Spend[Total Category Spend] )
Share of Voice = DIVIDE ( [Sum of Spend], [Sum of Total Category Spend] )
Proud to be a Super User!