Forum Discussion

Kubakkk's avatar
Kubakkk
Regular Visitor
5 years ago
Solved

Total value

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
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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