Solved: row filter with multiple clauses - Page 2

kelbow · ‎09-09-2016

Hi,

I'm building a dashboard with a data set where I want to filter the rows down by multiple OR clauses. It appears to do so, however, when I apply the filter, it only retains the last two clauses. Is this a known restriction?

Here's what I get;

= Table.SelectRows(#"Renamed Columns", each [OwnerLogin] = "officedev" or [OwnerLogin] = "onenotedev" or [OwnerLogin] = "onedrive" or [OwnerLogin] = "microsoftgraph" or [FullRepoName] = "Microsoft/Resource-Static-Analysis")

But generally speakig, the result only gives me rows filtered to the last two:

[OwnerLogin] = "microsoftgraph" or [FullRepoName] = "Microsoft/Resource-Static-Analysis"

Suggestions?

v-shex-msft · ‎09-11-2016

Hi kelbow,

I agree with ankitpatira’s point of view, it seems more suitable than use query edit.

Based on test, I can’t reproduce your issue, it works well, can you provide more info about this operation? Before you add filters, please check if there are records meet [OwnerLogin] = "officedev" or [OwnerLogin] = "onenotedev" or [OwnerLogin] = "onedrive".

Test sample

Power query formula:

let

    Source = OData.Feed("services.odata.org/V4/Northwind/Northwind.svc"),

    Employees_table = Source{[Name="Employees",Signature="table"]}[Data],

    #"Filtered Rows" = Table.SelectRows(Employees_table, 

    each [City] = "London" 

    or [City] = "Redmond" 

    or [City] = "Tacoma" 

    or [City] = "Seattle" 

    or [Region] = "WA")

in

#"Filtered Rows"

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

row filter with multiple clauses

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly