Forum Discussion

Vero85's avatar
Vero85
Regular Visitor
2 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Vero85 , Try a measure like

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Vero85 , Try a measure like

 

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