The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
my objective is to create a measure that show best N values and the sum of others, in a context of dashboard where, as the user click a measure, the graphics change the content.
Moreover, the dataset is of huge dimension, that makes it harder and also the performance should be considered.
Here is a semplification and explanation:
SALES | ||||
ProductID | Sales | Quantity | Profit | Discount |
A1 | 210 | 3 | 30 | 0 |
A1 | 70 | 1 | 10 | 0 |
A2 | 180 | 2 | 40 | 0,2 |
B1 | 50 | 2 | 7 | 0,4 |
B2 | 70 | 7 | 9 | 0 |
B2 | 140 | 14 | 18 | 0 |
The fact table has many dimensions that are related to the final dashboard; to make the dashboard dynamic, I create a SWITCH measure that refers to an unrelated table, that looks like this:
DIMENSION |
TotalSales |
TotalQuanity |
TotalProfit |
TotalDiscount |
its aim is to calculate each dimension, based on the user selection.
I tried many different approaches but really can't get how to make it working as I want;
Hope that I've been exhaustive,
Thanks to everyone that answers,
Dario.
Solved! Go to Solution.
This article might be what you are looking for.
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
This article might be what you are looking for.
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Thanks, it is good, but I m looking for something better in terms of performance
Best to work with calculated columns then. Do a topn and add a new column with an IF statement of the product name or label it as other. This is not dynamic / will be calculated at load time, but will perform way better.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Were you able to solve this one?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
48 | |
33 | |
30 | |
23 | |
20 |