Forum Discussion

cmcgo3's avatar
cmcgo3
Helper II
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 

cmcgo3's avatar
cmcgo3
Helper II
3 years ago

I am trying to add another feature; having some challenges with creating a measure....

 

 

Flag =
var _count=COUNTX(ALLSELECTED('Scores'),'Scores'[name])
var _per=_count*0.30
var _rank=RANKX(ALLSELECTED('Scores'),CALCULATE(SUM('Scores'[score])),,DESC)
return
IF(
    _rank<=_per,1,0)
 
Total Students = COUNTROWS(FILTER('Scores','Scores'[Flag]=1))
 The output for total students is 20; which is correct.
How would I write a measure that would capture what type of automobile a student drives based on the filtered total of 20.  For example, of those 20 students, 3 students have "Chevrolet" as automobile.  What measure would you write to get a total of 3?
 
I have been "stuck" on trying to create this calculation.
 
Best Regards,
 
Chris C.