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],

[FISC_WEEK_RLTV],

sum([REVN_AS_SLD_DISC_USD]) REV

from

[dbo].[vw_Dell_Order_Details]

where MKT_REGION_CALC = 'India' and [FISC_QTR_RLTV] = '-1'

Group by

MKT_REGION_CALC,

[MKT_PROD_LVL_2_NM],

[MKT_PROD_LVL_2_NM],

[COUNTRY],

[FISC_QTR_RLTV],

[FISC_WEEK_RLTV]

having sum([REVN_AS_SLD_DISC_USD]) > 1000000

Need Help

3 Replies

  • 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.