Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |