Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
So I am quite new to PowerBI, and my knowledge of DAX is very limited. I am building a dashboard in which we would need a dynamic weighted value of the Grossmargin and turnover by consumer unit.
I would like to be able to filter by Product, month and city, and depending on how I filter I could see how the Grossmargin and turnover by consumer unit responds.
I would need the Grossmargin to be dynamically weighted depending on the product and total turnover of the city. Same for the turnover by consumer unit, but in this case weighted by product and sales in consumer units.
Please let me know If I explained myself properly. I can also share with you a sample dataset so you could find the proper way of dealing with this.
Many thanks,
Emilio
Hi @Anonymous ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |