Dax function not working properly after os list separator change

[mpadros]

Not sure how to describe this, but I found that after changing my OS list separator from ';' to ',', some dax measures stopped working. 

eg. this formula returned all 0's where before it was working properly:

#Participating sites = CALCULATE(if(COUNTROWS(Org...) > 0;1;0);OrganisationInfoG....[Sel...] = "Selected")

I didn't get any 'hard' errors, just strange results. All issues were resolved after changing the OS list separator character back to its original value.

Anyone else experienced this?

Cheers

Marc

[v-qiuyu-msft]

Hi @mpadros,

The list separator used in DAX need to be matched with the is machine list separator to ensure the DAX work.

Best Regards,
QiuyunYu