Forum Discussion
Solved
Need a Dax Measure -Help !!
Lets say I had 200 students with a list of average scores from 0 to 100. There are also two filters, a date filter by week and a second filter for location of student. There was also a condition c...
Hi cmcgo3 ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Flag = var _count=COUNTX(ALLSELECTED('Table'),'Table'[StudentID]) var _per=_count*0.1 var _rank=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[average scores])),,DESC) return IF( _rank<=_per,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
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 cmcgo3 ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Flag =
var _count=COUNTX(ALLSELECTED('Table'),'Table'[StudentID])
var _per=_count*0.1
var _rank=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[average scores])),,DESC)
return
IF(
_rank<=_per,1,0) 2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
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
THANK YOU!, THANK YOU!, THANK YOU !! It works great for me!!!!!