Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
datadelta
Helper III
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
TheoC
Super User
Super User

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:

 

  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!

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

View solution in original post

4 REPLIES 4
TheoC
Super User
Super User

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:

 

  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!

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

Got it!

 

Thank you!

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

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.