The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have this use case and i need some input.
I need a logic to check on the same Billing Group Name that appeared twice for the same date: 3/14/2024. For this case, plc-gcp appeared twice but having 2 different values for Type namely FORECAST and ADJUSTED. I need to flag out as 1 for ADJUSTED and 0 for FORECAST. For the other Billing Group Name that occurs just once, I also need to flag out as 1, so that i can filter only 1 in my visuals. How to achieve this? TQVM.
Sample data:
Expected Result:
pls try this
Thank you @Ahmedx for the suggested solution, however i still encounter error below: What could be the reason for this?
in the SUMMARIZE function I have only 2 columns from one table, but it looks like you have 3 and one of them is from another table
SUMMARIZE(ALLSELECTED('Table'),
'Table'[Billing Group Name], // it is column 1
'Table'[Type] // it is column 2
),
Hi @Ahmedx
Thanks for your swift response. I am using 2 columns as well from the same table. This is the real table name and column names. I just apply the same logic with the real data. That's all.
maybe it’s because of the long column name, I can’t say for sure
Hi @Ahmedx I tested again on the syntax you've used on my newly created test Table.
It gives error. But your first working didnt show any error.
maybe due to the power bi version
you can share a file with a measure with an error
Which version are you using? The version i am using is Version: 2.123.684.0 64-bit (November 2023). May i know how to upload PBIX file to you? Can send via Private Message?
The link is not working for me. I cannot share the PBIX file because i am on company device. Could you share with me your PBI version and the pbix?
Hi @Ahmedx
I can still see the error in your PBIX file. Could this be due to PBI Desktop version issue?
here is my version from December 23
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |