Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am stuck with creating a measure.
I want to display in a table the total value of offers that are in the 'pipeline'. My issue is that some offers, have multiple sub-offers that have an has_approval_task = true. If this is the case I only want to display one of those sub-offers.
So for example. HB00030 has three offers, of which two have an has_approval_task = true. If this is the case I only want to display 1 of those 2 sub-offers. HB000037 has the same thing, but with 3 suboffers who have an has_approval_task = true.
Other requirements that this measure should have is that the columns: approval, finished_on and approval_cancelled_at should be empty.
Can anyone help with this?
You may try RANKX to add a column.
https://community.powerbi.com/t5/Desktop/DAX-Grouping-tagging/m-p/189391#M83354
Thanks for your reply @v-chuncz-msft ,
However, I prefer to create a measure because I want to keep my file small.
Do you know a solution where I can solve my problem using a measure?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |