powerbi - How to filter a Power BI table with column one filtered by column 2 - Stack Overflow

admin管理员组

文章数量:1392101

i'm trying to filter a table in PBI but i struggle with it so much. I have 2 columns, col1 can only have 2 values, 1 or 2. Col2 in a Product number, and can have mutliple occurence for the same number. I want to filter the table to only display one product number per distinct value of Col1. My final goal is to have maximum 2 line per product number in my table.

Here is an exemple of what my table looks like now:

Column 1	Column 2
1	123456
2	123456
2	123456
2	123456
1	999999
1	999999
1	999999
2	999999

i'm trying to filter a table in PBI but i struggle with it so much. I have 2 columns, col1 can only have 2 values, 1 or 2. Col2 in a Product number, and can have mutliple occurence for the same number. I want to filter the table to only display one product number per distinct value of Col1. My final goal is to have maximum 2 line per product number in my table.

Here is an exemple of what my table looks like now:

Column 1	Column 2
1	123456
2	123456
2	123456
2	123456
1	999999
1	999999
1	999999
2	999999

And this is what i want to achieve :

Column 1	Column 2
1	123456
2	123456
1	999999
2	999999

• powerbi

Share Improve this question Follow asked Mar 11 at 17:07 Nico DujaNico Duja 133 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

you can try in PQ select two columns and remove duplicates

or you can use DAX to creat

Table 2 = SUMMARIZE('Table','Table'[Column 1],'Table'[Column 2])

本文标签： powerbiHow to filter a Power BI table with column one filtered by column 2Stack Overflow