Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Distinct values with or statement

Hello everybody, I have got a problem with using distinct values. Some context: I'm working with a dashboard where people can select a beginning and ending date with two slicers. I harvest the...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

How about using Or instead of ||? 

 

CALCULATE(DISTINCTCOUNT('Data verstrekkingen'[combinatie BSN & ZIN]);
FILTER('Data verstrekkingen';'OR(Data verstrekkingen'[Product begindatum]>dynamicend, 
'Data verstrekkingen'[Product einddatum] < dynamicbegin))

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for your respons! I tried it, but sadly it does not work. It gives the same result as with the "||" symbol. Have you got any other suggestions?

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous,

       

      Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

       

      Regards,

      Frank