Forum Discussion
Solved
Using Quick Measure to Divide Two Visuals
I have the following quick measure for dividing: 2021 Totals divided by Sum of 2021 Specific Total= DIVIDE(Sum('Aug YTD Total Sales'[2021 Totals]),SUM(Umbrellas[2021 Total]), 0) It allows for...
Hi datadelta
Are you able to provide a little more detail around your Data Model and the relationship(s) between the Total Sales and the Umbrellas table?
In any instance, I would recommend giving the following a go:
- Division Measure as % = SUM ( 'Aug YTD Total Sales' [2021 Totals] ) / SUM ( 'Umbrellas' [2021 Total] )
- Click on [Division Measure as %], go to Measure Tools in Ribbon, change Format to Percent.
Let me know if this helps!
Theo 🙂
