Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Query in DAX

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.Dispo...
Show and Tell
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
quentin_vigne
Solution Sage
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you so much quentin_vigne It worked!!!

     

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