Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Measure Help - Need extra filter step in current measure

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])),CALC...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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) )

amitchandak's avatar
amitchandak
Super User
4 years ago

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) )