Need urgent help

[Georgia_H]

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:

[Ahmedx]

you can upload it on 1 driver or google drive
or this

https://dropmefiles.com/

[Ahmedx]

pls try this

[Georgia_H]

Thank you @Ahmedx for the suggested solution, however i still encounter error below: What could be the reason for this?

[Ahmedx]

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
), 

[Georgia_H]

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.

[Ahmedx]

maybe it’s because of the long column name, I can’t say for sure

[Georgia_H]

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.

[Ahmedx]

maybe due to the power bi version
you can share a file with a measure with an error

[Georgia_H]

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?

[Georgia_H]

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?

[Ahmedx]

 pls try

[Georgia_H]

Hi @Ahmedx 

I can still see the error in your PBIX file. Could this be due to PBI Desktop version issue?

[Ahmedx]

here is my version from December 23