Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have a table in my report that looks like this
But i'd like to filter the data such that my table should only show the transactions with Purchase orders (PO) where status = "Received". I am expecting my table to look like this,
What could be the dax formula to filter this?
Thank you so much for your help.
Hi @Anonymous You can create filter for column Status and can select the "Received Status". This will be visible on dashboard. If you do not want it to be visible then you can use the Filters pane (on the left of Visualization pane) and can use the field - Apply filters on Visual and use Status column to apply it.
Could you please mark this as a solution if this works for you.
Thanks
Radhika
Hi @Radhika2605 thank you for your reply. I understand what you're suggesting however I need only the transactions with Purchase Orders where status = Received . The transaction should not have a PO with Waiting status under it. So I only need the highlighted ones
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |