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.
Good Afternoon,
Building a report with dynamic sale ranking (e.g.: 5,10, 25, 50, All). The ranking formula used is:
Date | Part Number | Invoiced Sales | Virtual Summary Rank Based on Summary |
1/1/21 | ABC | $1.00 | 1 |
1/5/21 | XYZ | $5.00 | 2 |
2/5/21 | ABC | $7.00 | 1 |
4/5/21 | ZZZ | $0.75 | 35 |
"The rank summary is dependent on the current year selected and can change by period selected. My thought is that if I selected the top5 for 2021, for example, then I could virtually add this to a sale detail table and then write another Dax that picks up that ranking in the virtual detail table."
Sorry, you cannot add anything to a base table outside the design phase. Base tables are STATIC, which means the numbers in their columns will not change if you start clicking anything that's in a report. And also, it's not possible to help you because one can't write DAX and model data in a vacuum.
Thank you daxer. I will put together a sample PBIX file.
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 |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |