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 Morning,
I'm new to DAX
So I have this Dataset(Values Removed):
From it I did a Measure:
The Idea is to show the 15 Worses of this measure inside a Table:
Since its a Measure I was not able to filter by TOPN using the Visual Filter.
So What i thought was to do another Measure, a RANKX that would RANK the worst values of DesvioOrcadoAtéOMesAtual Measure and then use the Visual Filter to Filter numbers smaller than 15:
[EDIT]:
The Problem was that as we can see the "Pos" Column repeat a lot of time the same RANK Number.... And the values are different so it should not.
I want to be able to filter by the left filter of departaments, so when has no filter i would show the worst values at all and when its filtered by departament it would show the 15 worses values of that departament....
Believe the problem is linked to the CALCULATE measure , perhaps the FILTER is messing with the values... but aint sure....
HI @Anonymous ,
See if these help
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
Regards,
HArsh Nathani
Thanks Harsh Natani,
The thing is the values in the column i want to rank are not the same... In fact they are quite different.... So the tutorial did not help... But thanks a lot!
Regards,
[EDIT]
Just to Show that the RANK has no sense at all(sorry for the img quality, forgot to ss before
[/EDIT]
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 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |