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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

    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'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