Urgent request: SQL to DAX

[Anonymous]

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

[mauriciosotero]

Hi,

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

[Anonymous]

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

[dax]

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.