Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
Thank you so much.
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
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.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |