Changing the value in a matrix based on row label

[Analysis1103]

Hello everyone! I had a measure that was able to change the value in a matrix based on the row label but for some reason it does not appear to work anymore. The measure is as follow:

Measure =

IF(

    SELECTEDVALUE(Table[Column]) = "Row Name",

    0,

    [Measure Calculation]

)

The measure now does the calculation and doesn't do the zero logic. The matrix has more than one column (based on a single column from a table) if that matters. The result I would like is for when the row is "Row Name", the matrix shows 0 for all cells in that row.

[Anonymous]

Hi @Analysis1103 

Try the folloing measure

Measure =
IF(
    HASONEVALUE(Table[Column]) && SELECTEDVALUE(Table[Column]) = "Row Name",
    0,
    [Measure Calculation]
)

If the measure above doesn‘t help slove your problem, please provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Analysis1103 ,  Try

Measure =
IF(
SELECTEDVALUE(Table[Column]) = "Row Name",
0,
[Measure Calculation]
) +0

or

Measure =
IF(
SELECTEDVALUE(Table[Column]) = "Row Name",
calculate( 0, Table[Column]) = "Row Name),
[Measure Calculation]
)

[Analysis1103]

Thank you for the suggestion but unfortunately these did not work. The selected value logic doesn't seem to flag the row, thus the measure calculation at the end of the if statement is executed.