Reply
abfdjuk
Helper I
Helper I
Partially syndicated - Outbound

Exclude values less than X total hours

I have data as per below for many companies and I want to create a page filter which will remove any companies that have their total hours less than 100. I have tried using the filters but it doesn't seem to work. Here is a sample of the data:

 

Law firms - NameFees - Time
A200.00
B150.00
C10.00
D65.00
A120.00
A12.00
B10.00

 

1 ACCEPTED SOLUTION
BIswajit_Das
Super User
Super User

3 REPLIES 3
BIswajit_Das
Super User
Super User

Syndicated - Outbound

You can do this
x1.PNG

BIswajit_Das
Super User
Super User

Syndicated - Outbound

Hello @abfdjuk here's a something that might be helpfull

T1.PNGT2.PNGT3.PNG

Syndicated - Outbound

Thanks for your respone. From seeing this what I actually want to do is to total the hours for each law firm, e.g. law firm A = total hours 332, B = 160, C = 10, D= 65 and then exclude/include after that. How would I achieve that?

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)