Calculate statement with IF

[Rapports]

Hello, 

please i have do this mesure (Total_Absence/Seance = CALCULATE([Total_Seance_Planifiee],rpt_adAttendanceDetail_vw[P/A]="A") ) it works but the problem is when we dont have a "A" and we have a "P"  it give a blank, I need it to give me a 0 instead of blank how  can i fixe it ??? 

[AndrewPF · Accepted solution]

This may work:
Total_Absence/Seance = if(isblank(CALCULATE([Total_Seance_Planifiee],rpt_adAttendanceDetail_vw[P/A]="A")),0,CALCULATE([Total_Seance_Planifiee],rpt_adAttendanceDetail_vw[P/A]="A"))
or: 

if(rpt_adAttendanceDetail_vw[P/A]="P",0,CALCULATE([Total_Seance_Planifiee]))

Without seeing your data, I cannot decide which would work better.