Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

priority display

hiii

i want to display mitigated hit in matrix format fot 3 priorities.

i was using this formula

i need to use // in front of priorty to get in matrix for mat but here i am not been display any values but query is executed successfully.

M HIT = CALCULATE (COUNT ( Query1[Priority] ),FILTER (Query1,Query1[SLA Status] = "FULFILLED"&& Query1[Exempted SLA] = "N"
// && Query1[Priority] = "PLI_4HR"))
+ CALCULATE(COUNT( Query1[Priority] ),FILTER(Query1,Query1 [SLA Status] = "EXPIRED"
// && Query1[Priority]="PLI_4HR"
&& Query1 [Exempted SLA] = "Y"))))

2 Replies