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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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