Forum Discussion
Helper ITwo 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:
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.
Solution SageYou haven't supplied much information on your model, so it's impossible to guess the correct table names or the measure that produces the current numbers, but I suggest to remove the current filters on the visual and create a measure like this:
combined_measure =
CALCULATE([base_measure], dim1[bincode] IN {"ASSEMBLY CONS","CONSUMPTION", "SHIP"}, dim2[entryType]="Movement")
+ CALCULATE([base_measure], dim3[User]="PICK", dim2[entryType]="Negative Adjmt", dim4[zoneCode]="SHIP")
Helper II don't need to combine the values based on the filter. I need to assign them to different users as the origianl question suggests