Dynamic Format for Measures - Does not display comma?

[ColinRE]

All,

Dynamic Dax format works like a charm - mostly! Some values show 2, 4 or currency format. The only issue is the comma seperator for 1000's doesn't work. It uses the #,##0.00 format but doesn't work. Tried many other things. Is this a bug? Ideas? 

The visual (mostly works):

The measure: 

dynamic format DAX:

Table view

[ColinRE]

So it looks like there was a formula issue on my side yielding unexpected results. Thanks for building a sample test and validating it works. The formula I used reads off the table. 

[Ritaf1983 · Accepted solution]

Hi @ColinRE 
I tested the feature on my PBIX and this is no bugs

Check the logic of your calculations or share the PBIX with the sample if you need more assistance.
I also link my PBIX you can download it and follow my steps: Liml to a sample file 

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