Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bignadad
Helper I
Helper I

Two different filters based on Row value

I have these two table visuals that show the correct data and come from the same table

bignadad_0-1706029982506.png

I would like to have User PICK show up with the other in the same table.

The problem is the top table has different filters applied.

 

Here are the filters for the top table

bignadad_1-1706030062491.png

 

And here are the filters for the bottom table

bignadad_2-1706030085674.png

 

How can I combine bothe these tables with different filters?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

vzhengdxumsft_0-1706075608543.png

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:

vzhengdxumsft_1-1706075608549.png

 

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.

vzhengdxumsft_2-1706075618598.png

 

Links of how to use field parameter:

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

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.

View solution in original post

6 REPLIES 6
sjoerdvn
Super User
Super User

You 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") 

 

 

I don't need to combine the values based on the filter. I need to assign them to different users as the origianl question suggests

Anonymous
Not applicable

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:

vzhengdxumsft_0-1706075608543.png

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:

vzhengdxumsft_1-1706075608549.png

 

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.

vzhengdxumsft_2-1706075618598.png

 

Links of how to use field parameter:

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

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.

I am trying to implement the measure with if then you suggested.

 

I tried this buts its not working

Measure = IF(
            SELECTEDVALUE(warehouseEntry[user])="PICK",
            FILTER(warehouseEntry,warehouseEntry[entryType] = "Negative Adjmt."),
            FILTER(warehouseEntry,warehouseEntry[entryType] = "SHIP")
            )
 
I didn't include it above but there are multiple conditions that need to be met.
If user = PICK then entryType = "Negative Adjmt." and Zone Code = "SHIP"
else
Bin Code = SHIP|Consumption and entryType = Movement.
 
How can that be implemented in your suggestion?
123abc
Community Champion
Community Champion

To combine two tables with different filters in a Power BI report, you can use the "Edit Interactions" feature and create a relationship between the tables. Follow these steps:

  1. Edit Interactions:

    • Select the visual (table) that you want to interact with the other visual.
    • Go to the "Format" pane (on the right side).
    • Click on "Edit interactions" (paint roller icon).
  2. Define Relationships:

    • Select the visual you want to interact with.
    • Go to the "Model" view.
    • Ensure that you have a common field between the two tables (e.g., a unique identifier) on which you can create a relationship.
  3. Create Relationship:

    • Drag the common field from one table and drop it onto the corresponding field in the other table.
  4. Filter Direction:

    • After creating the relationship, you can set the filter direction. In your case, it seems like you want the "User PICK" table to show data based on the filters applied to the top table.
    • To set the filter direction, click on the relationship line between the tables and choose the appropriate filter direction.
  5. Review:

    • Go back to the report view and verify that the tables now interact with each other based on the defined relationship.

By setting up relationships and using the "Edit Interactions" feature, you can control how visuals in Power BI interact with each other. This allows you to have different filters on different visuals while still ensuring that they work together when needed.

 
 

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

 

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

I am not needing to filter data between two different tables.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.