Forum Discussion
Calculate a rate
Hello community, Please help me to solve this question: I have this database How I can calculate the A rate on the total A+P for the given student knowung that this operation must be don...
Rapports , Create measure like
Divide( calculate(Sum(Table[Attend]), filter(Table, Table[Status Absence] = "A") ), calculate(Sum(Table[Attend]), filter(Table, Table[Status Absence] in{ "A", "P"} ) ))
or
Divide( calculate(Sum(Table[Attend]), filter(Table, Table[Status Absence] = "A") ), calculate(Sum(Table[Attend]), filter(all(Table[Status Absence]), Table[Status Absence] in{ "A", "P"} ) ))
both of mesure give me 0.