Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Dax function not working properly after os list separator change

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

 

Status: New
Comments
v-qiuyu-msft
Community Support

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