Forum Discussion

mahra-in's avatar
mahra-in
Icon for Helper II rankHelper II
8 years ago
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 row...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi mahra-in

     

    Try this MEASURE

     

    =Divide(Calculate(COUNTROWS(TableName),
TableName[Delievry]="On Time"),
COUNTROWS(TableName))
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi mahra-in

 

Try this MEASURE

 

=Divide(Calculate(COUNTROWS(TableName),
TableName[Delievry]="On Time"),
COUNTROWS(TableName))