Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Urgent request: SQL to DAX

  Can someone help me to get the DAX equivalent for the below :  select count(distinct DW_ACCT_ID) #ACCT, MKT_REGION_CALC, [MKT_PROD_LVL_2_NM], [MKT_PROD_LVL_2_NM], [COUNTRY], [FISC_QTR_RLTV],...
Need Help
mauriciosotero's avatar
mauriciosotero
Resolver III
6 years ago

Hi,

 

For each propose do you want this DAX? I am asking because the DAX expression depends of the context.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes need all of this columns..  only Revenue comes from Measure table rest of them from Dimension table

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi arun_R2, 

      Yes, as mentioned above, the result willl be casued by context. So you need to tell me how you design your visual (your sample and your expected output), then I will help you more correctly. In addition, you also could refer to my sample for details.

       

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.