topic Re: HIT calculation for DAX calculation in DAX Commands and Tips

HIT calculation for DAX calculation

Anonymous — Tue, 28 Jul 2020 20:56:30 GMT

hii

i am trying to do the hit of sla by considering 3 conditions. the output i need to get after the operation is EXEMPTED but i am not getting it. Previously i did using COUNTIF function in excel.

can someone help me

HIT = CALCULATE(COUNTX(Query1[Priority]= "PLI_NBD"),FILTER(Query1[SLA Status]="FULFILLED") && (Query1[Exempted SLA]= "N"))

Re: HIT calculation for DAX calculation

Greg_Deckler — Tue, 28 Jul 2020 21:01:22 GMT

Anonymous - See if this helps: https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077

Re: HIT calculation for DAX calculation

Anonymous — Tue, 28 Jul 2020 21:46:18 GMT

hiii greg

i tried using those operations but i count try to get the output.i am getting an error

The COUNT function only accepts a column reference as an argument.

can you plz me to solve this

HIT = COUNTX(COUNT (Query1 [Priority] = "PLI_NBD" ), FILTER( Query1[SLA Status]="FULFILLED" && Query1 [Exempted SLA]= "N"))

Re: HIT calculation for DAX calculation

mahoneypat — Tue, 28 Jul 2020 21:58:02 GMT

Please try this approach

HIT =
CALCULATE (
COUNTROWS ( Query1 ),
Query1[Priority] = "PLI_NBD",
Query1[SLA Status] = "FULFILLED",
Query1[Exempted SLA] = "N"
)

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Re: HIT calculation for DAX calculation

Anonymous — Tue, 28 Jul 2020 22:14:25 GMT

Hii mohit

i tried using the query u have provided its not showing any error its executed successfully but in the output its showing both exempted and unexempted .

can you help me with this

Thank you

Re: HIT calculation for DAX calculation

Anonymous — Wed, 29 Jul 2020 04:29:16 GMT

Hi Anonymous ,

Try this

HIT = CALCULATE ( COUNT ( Query1[Priority] ), FILTER ( Query1, Query1[SLA Status] = "FULFILLED" && Query1[Exempted SLA] = "N" && Query1[Priority] = "PLI_NBD" ) )

HIT = COUNTROWS ( FILTER ( Query1, Query1[Priority] = "PLI_NBD" && Query1[SLA Status] = "FULFILLED" && Query1[Exempted SLA] = "N" ) )

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)