Forum Discussion

Georgia_H's avatar
Georgia_H
Helper I
2 years ago

Need urgent help

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:

 

 

Need Help
Show and Tell

13 Replies

    • Georgia_H's avatar
      Georgia_H
      Helper I
      2 years ago

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

       

       

      • Ahmedx's avatar
        Ahmedx
        Super User
        2 years ago

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