Need help with Dax

[Vero85]

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 🙂

[amitchandak · Accepted solution]

@Vero85 , Try a measure like

Divide( countrows(filter(Table, Table[Success?]= "Yes") , Table[ID.Student]) , countrows(Table[ID.Student]) )