Measure in row and both in columns

[Digger]

How to add measure which will be fixed and not go over months

I want only one comun for this measure not on each month

[mh2587]

This make no sense please elaborate the scenario

[Digger]

@mh2587 
i want measure3 on rows 

Expected result

[Anonymous]

Hi @Digger ,

When you put [Measure 3] under the Values option on the matrix, this will inevitably show up under each month. You can create the following measure to replace the field or measure already placed under the Values option, and the value of [Measure 3] will end up in the Column Total value. This may not be a good way to do it, but it can be used as a workaround...

Measure = IF ( ISINSCOPE ( 'Table'[month] ), SUM ( 'Table'[sales] ), [Measure 3] )

In addition, you can refer to the following blog to get it.

How to put the row and column subtotals in front of the matrix

1. Create a calculated table

Table2 =
UNION (
    DISTINCT ( 'Table'[Date] ),
    DATATABLE ( "Date", STRING, { { " Measure 3" } } )
)

2. Create a measure as below

Measure =
IF (
    SELECTEDVALUE ( 'Table2'[Date] ) = " Measure 3",
    [Measure 3],
    SUM ( 'Table'[Sales] )
)

Best Regards

[Digger]

@Anonymous  ty, but it not what i want to achieve, measure3 is not a total it is total of other measure

[Anonymous]

Hi @Digger ,

You can try the method which refer in the following blog.

How to put the row and column subtotals in front of the matrix

If the above one still can't help you get the expected result, please provide some sample data(exclude sensitive data) from the involved tables on the matrix visual and related visual settings. It is better if you can provide a simplified pbix file. Thank you.

Best Regards