topic Re: filter the table based on certain range of other calculated measure in DAX Commands and Tips

filter the table based on certain range of other calculated measure

osama_ayoub — Mon, 29 Aug 2022 10:04:55 GMT

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 — Mon, 29 Aug 2022 10:33:54 GMT

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.

osama_ayoub — Mon, 29 Aug 2022 19:39:28 GMT

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 — Tue, 30 Aug 2022 03:03:39 GMT

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

tamerj1 — Tue, 30 Aug 2022 09:49:49 GMT

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 — Sun, 04 Sep 2022 12:59:46 GMT

Thank you so much.