filter the table based on certain range of other calculated measure

[osama_ayoub]

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 

[tamerj1 · Accepted solution]

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.

[osama_ayoub]

Thank you so much.

[osama_ayoub]

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 

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

[tamerj1]

@osama_ayoub 

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

[tamerj1]

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.