Calculation Group format string impacting other measures

[cgonzalezjr]

I have run into an issue with formatting a measure not part of calculation group. If I select a calculation item (defined as SELECTEDMEASURE()) that has format string defined, the unrelated measure uses that format.  For example, I selected the Profit Pct Calculation Item (with the format string expression set as "0.00%;-0.00%;0.00%") from Metric Calculation Group, the measure Distinct Customer Cnt (defined as a whole number) is displayed as 40300.00% instead of 403.  The distinct Customer Cnt meaure uses whatever format is set for the selected Metric

Setup:

Result:

[sturlaws]

Hi, @cgonzalezjr,

in general, it is a good idea to include a pbix-file which highlights your issue. This makes it far easier to look into your issue.

In your case here, I think you just need to change how the slicer affects the card with the customer count:

to

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

How to Get Your Question Answered Quickly

[cgonzalezjr · Accepted solution]

Thanks that worked.  Can you explain why/how the selection of a calulation item in slicer affects the formatting of another measure?

[sturlaws]

Sure,

the slicer adds to the filter context when your measure is evaluated. And because you have filtered on the ordial of the calculation group, e.g. 2, all measures which has this as part of their filter context will be formated as [Profit prc]

Another way to solve your issue would be to change your switch-statement to something like this:

metric = 
var _name = calculate(selectemeasurename()) return
switch(true(),
,_name = "Sales Total",[Sales total]
..
..
) 

 Since you would have to hardcode the names of the measures here, I think I prefer to change how visuals interact.