Solved: Using Quick Measure to Divide Two Visuals

datadelta · ‎10-05-2021

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 the measure but returns $5 and if I change to "show as a percentage of total, it's 100%%.

Is there an issue with using a quick measure to divide one visual by another?

TheoC · ‎10-05-2021

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 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

TheoC · ‎10-05-2021

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 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

datadelta · ‎10-05-2021

Got it!

Thank you!

TheoC · ‎10-05-2021

Legend @datadelta!

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias