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

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