Forum Discussion

puj831's avatar
puj831
Frequent Visitor
7 years ago

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...
Need Help
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

Hi@ puj831

 

You can try these two measures as below:

Everyone call acceptance:

Measure = var tmp =SUMMARIZE(Table2,Table2[ID],"Acc",CALCULATE(SUM(Table2[Accepted])),"totalCall",CALCULATE(SUM(Table2[Accepted])+SUM(Table2[Cancelled])+SUM(Table2[Rejected])),"Per",CALCULATE(SUM(Table2[Accepted]))/CALCULATE(SUM(Table2[Accepted])+SUM(Table2[Cancelled])+SUM(Table2[Rejected]))) return var MaxAcc=MAXX(tmp,[Acc]) return
SUMX(filter(tmp,MAX([Acc])=MaxAcc),[Per])

Most call accepted :

Measure 4 = var maxValueID = CALCULATE(maxx(TOPN(1, SUMMARIZE('Table2', Table2[ID]), [Measure], DESC), [id]), all(Table2)) return if(min(Table2[ID]) = maxValueID, [Measure], BLANK())

 Then drag filed ID and measure 4 into table visual

 

Result:

Here is Demo, please try it

https://www.dropbox.com/s/dkr3po7b7cd3i34/mode%20stats.pbix?dl=0

 

 

Best Regards,

Lin