cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## 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 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?
1 ACCEPTED SOLUTION
Super User

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:

1. Division Measure as % = SUM ( 'Aug YTD Total Sales' [2021 Totals] ) / SUM ( 'Umbrellas' [2021 Total] )
2. 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!

4 REPLIES 4
Super User

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:

1. Division Measure as % = SUM ( 'Aug YTD Total Sales' [2021 Totals] ) / SUM ( 'Umbrellas' [2021 Total] )
2. 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!

Helper III

Got it!

Thank you!

Super User

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!

Helper III

This is comparing the percentage of umbrella sales to total of all product sales.

I followed your instructions but it gave me a crazy number.  1914.71%

The overall number is 508,815 and the umbrella number is 104525 which is about 20%

Thanks for helping.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors