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, I'm trying to divide different brand totals from a stacked dataset by unstacked totals of store numbers from a different dataset. Can someone help? Is there an easy dax for this? For example, I could have 1500 recommendations for Minute Maid Orange Juice on one stacked dataset and would like that number to be divdied by the number of grocery stores I called over all on an unstacked dataset.
Hi @kqrb75,
From current description, it's hard to imagine your scenario. Please post sample data to make the table structure and detailed values more clear. Also, show us your desired output. How do you want to visualize dataset? If possible, illustrate it with an image.
Regards,
Yuliana Gu
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
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |