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

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?