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?