Two different filters based on Row value

Hi bignadad 

You can try to create a MEASURE to categorize your [USER] column using the IF function or the Switch function.

Then use the Filter function to filter each.

Links of other DAX functions you may use:

DAX overview - DAX | Microsoft Learn

For example, I create a set of sample:

Then create a measure:

Measure = IF(
            SELECTEDVALUE('Table'[user])="C",
            MAX('Table'[Column1]),
//when [user] = C, the matrix show [column1]
            MAX('Table'[Column2])
//If [user] not equal to C, the matrix show [column2]
            )

The result is as follow:

You can also try the field parameter.

Fields parameter is a feature that allows users to choose which column to use to slice values in a Power BI visual.

For example, by creating a fields parameter you can very easily build a report where you can slice by Brand and Category, as in the following figure.

Links of how to use field parameter:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn [4125-0344-ac6-31a1]

Fields parameters in Power BI - SQLBI

Best Regards,

Zhengdong Xu

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