Forum Discussion
Solved
Need help with Dax
Hi!
I am new with Dax and need help for this specific formula.
Original Table
ID.Student | ID.Class | Success? |
1 | 11 | Yes |
| 2 | 12 | Yes |
| 3 | 13 | No |
| 4 | 11 | No |
| 5 | 12 | Yes |
| 6 | 13 | Yes |
| 7 | 11 | No |
| 8 | 12 | Yes |
| 9 | 13 | No |
| 10 | 11 | No |
I would like to measure the success rate (number of students who "success = yes divide by the number of students) per Class id ?
Can anyone help me with this please 🙂
Vero85 , Try a measure like
Divide( countrows(filter(Table, Table[Success?]= "Yes") , Table[ID.Student]) , countrows(Table[ID.Student]) )
1 Reply
- amitchandak
Super User
Vero85 , Try a measure like
Divide( countrows(filter(Table, Table[Success?]= "Yes") , Table[ID.Student]) , countrows(Table[ID.Student]) )