BPARules: Support for Measure Formatting - Dynamic

[jjarrinf]

The BPARules is not supporting "Dynamic" format.

When using this "Dynamic" format with clauses like this:

SWITCH(SELECTEDVALUE('Other Measures'[Measure]), "Net Sales","#,0", "Units","#,0", "UxA","0.##", "VxA","0.##", "VxP","0.##", "PPU","0.##", "% CV","0.0%", "% CV + Free","0.0%", "CV","#,0", "CV+Free","#,0", "%" ,"0.0%", "0#,##")

The rule "[Formatting] Provide format string for measures" is violated

[Eivind4]

You can modify the rule inserting this (and avoid DataType.String as well):

not IsHidden
and not Table.IsHidden
and string.IsNullOrWhitespace(FormatString)
and string.IsNullOrWhitespace(FormatStringExpression)
and DataType != DataType.String

I have sent some suggested changes in a separate issue, and will see if it will be updated in the default file as well.