Countif

[deniseb]

Hello, In my Power BI analysis, I evaluate all calls from our telephone system. This includes the duration per call. Now I would like to create a pie chart that shows how many calls lasted under 8 minutes, under 20 minutes and over 20 minutes. How should I proceed? I have already tried with a count formula but without success.

[amitchandak · Accepted solution]

@deniseb , If they are non overlapping you can create a  new column and use in pie visual

Type = Switch(true() ,

[Overlapping in Min] <8 , "Less Than 8",

[Overlapping in Min] <20 , "Less Than 20",

"More than 20"

)

If they are overlapping create measures and then do not use legends only use measures