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
I also wanted to add a table underneath that would give you totals. For this example, Total Students 20, Count of automobile I would want 3 and then percentage of total ...20 students / 3 chevrolet .15 or 15%. Any help would be greatly appreciated !!