Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I'm looking to create a measure to get the bottom 5 sales by Market without needing the use of slicers/ filters.
Is it possible to do this with a measure as I can do the top 5 but I'm struggling to do the bottom 5.
I have attached a sample PBIX and my sample Excel data also below.
Any help would be appreciated!
PBIX - https://drive.google.com/file/d/1k2h-CepPaYARqsROgRIkAlv60z2khZKP/view?usp=drive_link
Excel data - https://docs.google.com/spreadsheets/d/1FNQaZ4Eom6-FqzLvoCZl8t_mOPqXIOHA/edit?usp=drive_link&ouid=11...
Solved! Go to Solution.
Hi @gbarr12345
You can use a measure :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi,
Yo have just shared the download link of th e PBi file without showing the problematic visual/calculation. Build your visual and clearly show the problem there.
Apologies, I missed this message.
Please find the PBIX file with the dax attempt here - https://drive.google.com/file/d/1euNJ7rP3m1LALVXtiR8KdFQH9TY9v_HO/view?usp=drive_link
Hi,
I just dragged Market to the visual and your measure seems to work
That worked in the end, apologies my system was just acting up.
Thanks a million for your help Ashish as per usual!!
You are welcome.
Hi @gbarr12345
You can use a measure :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Rita,
Thank you for your response.
I tried your measure and it's showing as blank for me. Any idea why this is happening?
I can't know without seeing the pbix.
Please download the file that I attached in the first reaction and follow my steps.
If it still doesn't work, attach yours with the problem....
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
If you can to the Top 5 then you can do the Bottom 5 too - just revert the sort order.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |