Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use count that apply on a filter

I have this measure:   #avg grade to pass = DIVIDE(CALCULATE(SUM(StudentResults[result]); StudentResults[result] >= 5,5); DISTINCTCOUNT(StudentResults[studnr]))   It needs to calculate the avera...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Try this.

     

    #avg grade to pass = CALCULATE(DIVIDE(SUM(StudentResults[result]);DISTINCTCOUNT(StudentResults[studnr]));StudentResults[result] >= 5,5)
     
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.
    Looking for German Power BI content? Visit my blog.
    http://www.thinkbi.de/
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Try this.

 

#avg grade to pass = CALCULATE(DIVIDE(SUM(StudentResults[result]);DISTINCTCOUNT(StudentResults[studnr]));StudentResults[result] >= 5,5)
 
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Looking for German Power BI content? Visit my blog.
http://www.thinkbi.de/
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Nice! It works, did not know that you can use the calculate like that.