Forum Discussion

anjanikumar's avatar
anjanikumar
Icon for Helper III rankHelper III
4 years ago

Convert this SQL query to DAX measure

select opportunity_status, sum(opportunity_value) as sum_opp_value from ( select distinct opportunity_id , opportunity_status ,opportunity_value from web_analytics_dm.dm_behaviour_campaign_salesfor...
DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

anjanikumar , You can create a measure like

 

sumx(summarize(filter(dm_behaviour_campaign_salesforce, [business_unit]="SEF" && [date]= Date(2021,12,01)), [opportunity_id] , [opportunity_status] ,[opportunity_value]), [opportunity_value])

 

and use with opportunity_status is any visual

  • anjanikumar's avatar
    anjanikumar
    Icon for Helper III rankHelper III
    4 years ago

    amitchandak 

     

    Thank you so much for your response !!

     

    want opportunity_status  with Groupby .

     

    Convert below query as DAX.

     

    select opportunity_status, sum(opportunity_value) as sum_opp_value from (

    select distinct opportunity_id , opportunity_status ,opportunity_value

    from web_analytics_dm.dm_behaviour_campaign_salesforce dbcs

    group by opportunity_status