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.
Hii
i have a requirement to display dynamic Top N category based on country and i am using Matrix visual
i am using this DAX function
Solved! Go to Solution.
Hi @sarjensystems1 ,
I have changed your measure and I guess this time it will satisfy your need:
TopN Sales =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, [sales],
RANKX (
ALL('Table'),
[sales]
)
<= SelectedTop,
[sales]
)
And you will see:
For the related .pbix file,pls click here.
Best Regards,
Kelly
Hi @sarjensystems1 ,
I have changed your measure and I guess this time it will satisfy your need:
TopN Sales =
VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])
RETURN
SWITCH(TRUE(),
SelectedTop = 0, [sales],
RANKX (
ALL('Table'),
[sales]
)
<= SelectedTop,
[sales]
)
And you will see:
For the related .pbix file,pls click here.
Best Regards,
Kelly
Hi @sarjensystems1 ,
I'm not sure whether [sales] is a column or measure,but I tried to use your sample data and create a measure names [sales],when I select subcategory,it appears right, as you can see below:
For the related .pbix file,pls click here.
Best Regards,
Kelly
Hi,
Share some data and show the expected result.
I did not test it but
You might have to try ALLEXCEPT( Query1[Category]) in place of ALL( Query1[Category]).
Refer
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |