Switch measure on row matrix

[MCacc]

Hello, 

is there any way I can switch measure based on which value I have in my rows header in a matrix visual? 

I have done it with columns but never with rows. 

The measure I wrote down is this:

But once used in a matrix it shows no values.

Any idea why this happens?

Thanks

[Anonymous]

Hi @MCacc ,

I noticed that you said rows headers. You got multiple rows in your matrix, right?

For example,

For the above scenario, it is recommended that you try the field parameter.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

If there is a single field in the matrix row, matching the values in the matrix row fields returns different measures. Then I also tested it on my side, and like @audreygerred , it was able to return the result correctly. Please provide more details. If you can, please provide some dummy data along with the desired results, presented in a tabular format.

Best Regards,

Stephen Tao

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

[audreygerred]

Hi! Give this a whirl

SWITCH = SWITCH(TRUE(),

SELECTEDVALUE('Product'[Category]) = "Bikes", [Order Quantity],

SELECTEDVALUE('Product'[Category]) = "Accessories", [Sales Amount])

It worked when I tried it out - in below left screenshot I have category in rows and the switch measure in values. For Accessories we are seeing the Sales Amount and for Bikes we are seeing the Order Quantity.