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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors