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.Disposition = d.DispositionCode
and    d.Chargable = 'Y'

 

Thanks

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

6 Replies

  • 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