Total value

[Kubakkk]

Hi all,

I have a problem with values in matrix. Is it possible for the "udziały" columns to show only in Total and not next to each month?

Kind regards

[Anonymous · Accepted solution]

Hi @Kubakkk ,

You can create a measure as below to replace the field udziały on the matrix, please find the details in the attachment.

New_Udzialy = 
VAR _udzialy =
    CALCULATE ( SUM ( 'Table'[Udzialy] ) )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Data wystawienia].[Year] )
            && HASONEVALUE ( 'Table'[Data wystawienia].[Month] ),
        BLANK (),
        _udzialy
    )

Best Regards