Forum Discussion

cgonzalezjr's avatar
cgonzalezjr
New Member
4 years ago
Solved

Calculation Group format string impacting other measures

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 u...
Need Help
  • cgonzalezjr's avatar
    cgonzalezjr
    4 years ago

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

sturlaws's avatar
sturlaws
Resident Rockstar
4 years ago

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's avatar
cgonzalezjr
New Member
4 years ago

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

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    4 years ago

    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.