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])),CALCULATE(DISTINCTCOUNT(dev_meet_meeting_data[external_hcp_code])))
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) )

1 Reply

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