Calculated Groups in Tabular Editor Problem

[DHB]

Hi all,

I'm using calculated groups in Tabular Editor to format the data in the chart that I'm also using switching with.  The chart switches between two measures one of which I display as a whole number and the other to three decimal points.  That all works fine but there are a couple of issues I can't get around;

1. While the data labels conform to the formats specified in the calculated groups the total labels show as two decimal points for both measures.  I'd like these to conform to the same formats as the data labels but they don't and I can't work out where its getting the two decimal points format from.
2. The calculated groups are somehow interfering with completely unrelated explicit measures in other parts of my dashboard.  This occurs in three locations which all show the same number with the format specified in the supposedly unrelated calculated groups (whole number or 3dp depending on what I've selected in the switch).  The number itself is a mystery as it doesn't seem to relate to anything and one of the explicit measures should just show a date. Last Refreshed = FORMAT(LASTDATE('Refresh - Adelaide Time Zone'[Adelaide]),"mmm dd, yyyy hh:mm AM/PM").

Any tips or advice would be greatly appreciated.

Thank you,

DHB

[lukiz84 · Accepted solution]

Hi,

1) Look for the "Format String Expression" for each of the calculation items.

2) Calculation groups apply to all of your measures, unless you use IF(NOT(ISSELECTEDMEASURE(...)), SELECTEDMEASURE(), <yourCode>)

BR