cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
osama_ayoub
Helper I
Helper I

filter the table based on certain range of other calculated measure

Hi everyone 

I had a table (MB51) in power pivot and I created a measure to sum of one column in this table {Quantity},

Now I want to only filter this table based on certain range of first calculated measure

How can I do that?

Thanks in advance 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hello Again @osama_ayoub 

Please refer to sample file inluding couple of examples. Please let me know if you still need further help. We may also connect via zoom or teams.

1.png

View solution in original post

5 REPLIES 5
tamerj1
Super User
Super User

Hello Again @osama_ayoub 

Please refer to sample file inluding couple of examples. Please let me know if you still need further help. We may also connect via zoom or teams.

1.png

Thank you so much.

osama_ayoub
Helper I
Helper I

hi@tamerj1

thank you for your reply,but I can not understand it, let me explain my issue:

I have a table 1 like this 

osama_ayoub_0-1661801718008.png

the column[Order} has duplicated values and I want to sum values from column[Quantity]

after that I want to make a filter on only the rows in column[order] which has sum of  [quantity] greater than 0.

this table is connected with another one and I want only the order which has sum of  [quantity] greater than 0 to use it to make my report.

Thanks in advance.

Regards

@osama_ayoub 

Please share sample sample dat in a copy/paste format. 

tamerj1
Super User
Super User

Hi @osama_ayoub 
attached an example of how to use measures to filter a table in power pivot. Please let me know if you need any further help.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors