How to get the Column Level Total for Actuals

[smjzahid]

I have a matrix visual and I want to show Column Level Total for the column named ACTUALS (see snip below).

I tried to use the property of the matrix visual to show the column level total. However, with this approach all columns toals gets displayed namely (Planned, Actual, performance).

I just want to show the Total for Actual How can I achieve this using DAX or any other technique.

Note: I dont want to show Planned and Performance Total

and this is how my columns have been placed on the matrix visual

[alexa_0028]

Hi @smjzahid , try creating your measure like below :
TotalPlanned= IF(HASONEVALUE(<measure formula>), BLANK())

Performance= IF(HASONEVALUE(<measure formula>), BLANK())

[smjzahid]

Hi @alexa_0028 ,

Tried your approach, it is not totalling for the entire row, only seem to be totalling for the last column,

TotalActual = IF(HASONEVALUE(crf7a_WeeklyReportPVA[Actuals]), SUM(crf7a_WeeklyReportPVA[Actuals]), BLANK())

and missing total for few rows (see highlighted arrow shown)

[AlexisOlson]

If the columns have blanks, you'll still see a column; it'll just be empty.

Also, a measure always returns a single value, so I don't think your suggestion will work as you expect. You'd probably want to write something like IF ( ISINSCOPE ( Table1[Date] ), [Planned] ) instead.

[AlexisOlson]

I don't think there is a straightforward way to control which measures show totals but one workaround would be to turn off word-wrap on values and column headers and resize the columns you don't want to see to be effectively invisible.  You'll probably want to turn off "Auto-size column width" too to keep this adjustment from reverting.