Query in DAX

[Anonymous]

Hello Experts,

Could you please advise how do I get the below query results in column or measure?

select count(i.incident_id)
from   ATB_Incident i,
       ATB_Disposition d
where  i.Disposition = d.DispositionCode
and    d.Chargable = 'Y'

Thanks

[quentin_vigne]

Hi @Anonymous

The formula you are looking for will look like this : (You need to have relations betweens your tables)

Measure = CALCULATE(COUNT(Incident_id);Dispotion=DispositionCode;Chargable="Y")

It's not 100% exact as I don't really know what your table looks like but if you adapt it, it should work !

- Quentin

[Anonymous]

Thanks @quentin_vigne for your prompt response.

But its giving error at ";Dispostion" and at ";Chargable"

If I just plug the table names in measure it should look like 

Measure = CALCULATE(COUNT(ATB_Incident[Incident_Id]);ATB_Incident[Dispotion]=ATB_Disposition[DispositionCode];ATB_Disposition[Chargable]="Y")

Please help! Thanks..

[quentin_vigne]

@Anonymous

I read something wrong, my bad.

Here is something that should be correct : 

Measure = CALCULATE(COUNT(ATB_Incident[Incident_Id]);ATB_Disposition[Chargable]="Y")

Do you have a relation between your two table ? 

- Quentin

[Anonymous]

yes, I have join on tables like

ATB_Incident.Disposition = ATB_Disposition.DispositionCode

And query is

select count(i.incident_id)
from   ATB_Incident i,
       ATB_Disposition d
where  i.Disposition = d.DispositionCode
and    d.Chargable = 'Y'

Please advise, thanks!

[quentin_vigne · Accepted solution]

@Anonymous

I have an idea 

Enter this please and tell me if there is an error or no : 

Measure = CALCULATE(COUNT(ATB_Incident[Incident_Id]),ATB_Disposition[Chargable]="Y")

- Quentin

[Anonymous]

Thank you so much @quentin_vigne It worked!!!

So I can just go on adding more filter conditons in CALCUALTE dax?