Report Builder with DAX queries - comma character in parameter values

[garythomannCoGC]

As we know Report Builder uses the comma character as the parameter value delimiter.  Obviously this causes issues when comma characters exist within the parameter values themselves.  

With the Report Builder and DAX environment is there a way around this?

Have used the DAX code to replace comma delimited parameter values with the pipe character ('|') needed for pathcontains usage etc within my code base for multi-value parameters.   All and good but comma's are an issue.

[garythomannCoGC]

DAX pattern schematic that I use. No need to use RSCustomDaxFilter function 

[garythomannCoGC · Accepted solution]

DAX not SQL :}

DAX does not have the capability yet where you can create your own database functions.

Custom (Reusable) DAX Function   please vote :}

RSCustomDaxFilter 1) does not work in DaxStudio so is effectively useless and 2) do not want to waste time to test this because even if it does take care of any delimiter 1) makes it virtually useless.

[v-xiaotang]

Hi @garythomannCoGC 

Thanks for your reply. To help others find this post and vote for that idea faster, you can accept your answer as solution. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @garythomannCoGC 

Thanks for reaching out to us.

I find a related video, will it help? https://www.youtube.com/watch?v=htpoAyuWw5o

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.