Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi folks,
I need a help.
Is there something possible, I have created a measure. I want the measure value not to be filtered even other slicer I changed.
Changing the silver will only change the visual ,suppose earlier it was showing 10 rows with different values now it will show 6 rows with the same earlier value.
Solved! Go to Solution.
Hi @Nobie ,
I created some data:
You might consider using the IF() function to mark up and then put it in Filter to set it.
Here are the steps you can follow:
1. Create measure.
Rank =
IF(
[Count]=6,
RANKX(
FILTER(ALLSELECTED('Table'),[Count]=6),CALCULATE(MAX('Table'[Date])),,ASC),BLANK())
Flag =
IF(
[Rank]<=6&&[Rank]<>BLANK(),1,0)
2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Nobie ,
I created some data:
You might consider using the IF() function to mark up and then put it in Filter to set it.
Here are the steps you can follow:
1. Create measure.
Rank =
IF(
[Count]=6,
RANKX(
FILTER(ALLSELECTED('Table'),[Count]=6),CALCULATE(MAX('Table'[Date])),,ASC),BLANK())
Flag =
IF(
[Rank]<=6&&[Rank]<>BLANK(),1,0)
2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |