Solved: DAX Measure Help - Need extra filter step in curre...

Anonymous · ‎05-31-2022

Hi Experts

I need to add a filter step to the current measure so show only results where meeting flag is 1.

Measure

test = SUMX(

KEEPFILTERS(ALL(dev_meet_meeting_data[crmf_em_event_id])),CALCULATE(DISTINCTCOUNT(dev_meet_meeting_data[external_hcp_code])))

amitchandak · ‎05-31-2022

@Anonymous , Try like

Measure
test = SUMX(
KEEPFILTERS(ALL(dev_meet_meeting_data[crmf_em_event_id])),CALCULATE(DISTINCTCOUNT(dev_meet_meeting_data[external_hcp_code]), [meeting flag] =1) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

amitchandak · ‎05-31-2022

@Anonymous , Try like

Measure
test = SUMX(
KEEPFILTERS(ALL(dev_meet_meeting_data[crmf_em_event_id])),CALCULATE(DISTINCTCOUNT(dev_meet_meeting_data[external_hcp_code]), [meeting flag] =1) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube