percent of grand total

[Kopek]

Hello Everyone,

I know this question has been raised a few times.

I tried to find a solution, but without success.

I think i am close to solve my problem, but would appreciate your help!

I need to count how many Service requests have been solved in SLA.

My data looks like:

SR_NUMBER, RESOLUTION_SLA_MET (YES / NO column), and few more columns, but i think it's everything I need for this measure.

Let's say total number of SR is 1000 and 900 is resolved in SLA, so 90% or SRs is resolved in SLA.

When I try to do this in PowerBI it ALWAYS shows 100%.

I tried to implemented this measure:

SLA_Met = DIVIDE([All_Requests] , CALCULATE([All_Requests], all ('Service Request'[RESOLUTION_SLA_MET])))

all requestes - it's a measure where I count all my requestes.
(All_Requests = COUNT('Service Request'[SR_NUMBER])

Even though I use above SLA MET measure and I choose Resolution SLA Met - "yes" in visual fiter section it shows 100%.

Could you please let me know, what's wrong here ?

I need to have this interactive, so that I can use portfolio filters and show proper % for each portfolio. I don't want to calculate it for each portfolio manually. Hope it's possible.

Thanks a lot!

[Anonymous]

Try

SLA_Met = DIVIDE([All_Request], Calculate([All_Request],ALL('Service Request'))

i.e. without the column filter.

OR 

SLA_Met = DIVIDE([All_Request], Calculate([All_Request],FILTER(ALL('Service Request')))

[Kopek]

Hi Adetogni,

It works now.

I used %ofGrandTotal in visualisation.

Whereas I should have been used "no calculation" and everything works now.

Anyway, thanks for your help! 🙂

[Kopek · Accepted solution]

All works now 🙂