Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have the following quick measure for dividing:
Solved! Go to Solution.
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:
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
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:
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.