DAX SUM column based on multiple conditions

[prasadhebbar315]

I have 2 columns: Category and Escalated

The requirement is to calculate accuracy like the below excel calculation: That is Sum of Escalated when Category is Critical or High divided by Sum of Escalated.

How do I replicate this in PBI? Please help....

=(SUMIF(A2:B12,"High",B2:B12)+SUMIF(A2:B12,"Critical",B2:B12))/SUM(B2:B12)

Category	Escalated
High	1
Critical	1
Low	0
Moderate	1
High	1
Moderate	0
Critical	1
Critical	1
Low	0
High	0
Moderate	1

[tamerj1 · Accepted solution]

Hi @prasadhebbar315 

please try

=
DIVIDE (
CALCULATE (
SUM ( 'Table'[Escalated] ),
'Table'[Category] IN { "High", "Critical" }
),
SUM ( 'Table'[Escalated] )
)

[prasadhebbar315]

@tamerj1 Thanks this solution has worked