Forum Discussion
mode stats
how do you calculate the the ID who had Accepted the most number of calls (without knowing). So in the example, the mode ID is 1 because it acccepted 2 calls (more than any other ID) and reject...
Hi@ puj831
You can try to use measure as below:
Measure 3 = CALCULATE(SUM(Table1[Accepted]))/CALCULATE(SUM(Table1[Accepted])+SUM(Table1[Cancelled])+SUM(Table1[Rejected]))
Result:
Best Regards,
Lin
Thanks, however, how can I get it to show only 0.40, not the others. So it would be the the ID that has the most acceptances only. thanks!