Forum Discussion
Solved
Measure for % on Total
Please give me measure for below requirement
I have a column as
Delievry
On Time
Late
On Time
Not Available
On Time
On Time
Late
And the result I need is
Total there are 7 rows or values, On Time = 4/7 * 100=57.14%
Please help me
Hi mahra-in
Try this MEASURE
=Divide(Calculate(COUNTROWS(TableName), TableName[Delievry]="On Time"), COUNTROWS(TableName))
1 Reply
Hi mahra-in
Try this MEASURE
=Divide(Calculate(COUNTROWS(TableName), TableName[Delievry]="On Time"), COUNTROWS(TableName))