Forum Discussion

Fuzel's avatar
Fuzel
Frequent Visitor
7 years ago
Solved

Distinct Count of a Measure

Hello Folks, I'm fairly new to DAX world. I'm currently running into an issue that I'm not sure how to tackle. I have three different measures that make a distinct count of parts. All 3 measures appl...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Fuzel ,

    In your scenario, we cna use the OR() function to combine these three conditions like below:

    Measure = CALCULATE(DISTINCTCOUNT(TBL_GFE_NETINTAKE_PTC[ITEM]),FILTER(TBL_GFE_NETINTAKE_PTC,OR([filter1],[filter2],[filter3]))

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Fuzel ,

In your scenario, we cna use the OR() function to combine these three conditions like below:

Measure = CALCULATE(DISTINCTCOUNT(TBL_GFE_NETINTAKE_PTC[ITEM]),FILTER(TBL_GFE_NETINTAKE_PTC,OR([filter1],[filter2],[filter3]))

Best Regards,

Teige

Fuzel's avatar
Fuzel
Frequent Visitor
7 years ago

Hey TeigeGao  That worked well now. Made a slight mistake initially. Thanks for your response.