Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
102 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
125 | |
75 | |
74 | |
63 |