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,
Please view the below simplified table.
I would like to be able to provide the User three slicer options. Two ('Percent' and 'Top or Bottom') of which will be manually created through the 'Enter Data' method. The third will be the distinct values from the Status field in the table (for the table used in the example (above), the options would be In and Out). See below for a dummy mock-up of the slicers.
What I would like to do is return a table visual showing the Item No. and Duration (summed) ordered via a ranking method.
For example, let's pretend that 1% percent of the Status = Out records is only three Item No. records. Therefore if the User selected the following slicer options:
Percent = 1.
Top or Bottom = Bottom.
Status = Out.
It would return the below visual:
Notice how only three Item No. records are shown (we're saying that the filtered 1% equals just three records). The Item No. have had their Duration values summed and then are ranked/ordered in ascending order (as the user chose Bottom in the slicer).
How do I acheive this using DAX? This needs to be done via DAX. I've been following some examples on the next but something is clearly missing as it doesn't work.
If in your response it makes a difference, do be aware the user may choose to see the Top 5% of the records with the In status, or any combination.
Thanks in adavnce.
SQLBI did a video which I think will help with this - https://www.youtube.com/watch?v=3BAJMlojjVs
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |