Help with SUMMARIZE function

[rweb95]

Hello. I have two columns 'RateSchedule - Current[UtilityName]' and 'RateSchedule - Current[CompanyId]'. My goal is to have a table visual in the report that I can filter out utilities deemed as "Custom". If a [UtilityName] has an accompanying [CompanyId] then it should be considered "Custom". If [CompanyId] is blank, then it is considered "Global". And if a [UtilityName] has both, then it is "Global".

Example:

'RateSchedule - Current[UtilityName]'       'RateSchedule - Current[CompanyId]'

  ANEC-VA                                                                   6721   

  ANEC-VA                                                                   ------

  ANEC-VA                                                                   10484

  AEC                                                                            10733

  AEC                                                                            8413

  ACEC                                                                          ------

  ACEC                                                                          ------

In this example, ANEC-VA should be "Global", AEC should be "Custom", and ACEC should be "Global".

My problem is figuring out how to classify a [UtilityName] as "Global" when it has multiple rows that have blanks and IDs. I think SUMMARIZE is what I need to use, but I'm not entirely sure.

I'm fairly new to Power BI and I appreciate any help you can provide!

[amitchandak · Accepted solution]

@rweb95 , Try a new column like

if(countx(filter(table, [UtilityName] =earlier([UtilityName] ) && isblank([CompanyId])),[UtilityName])+0>=1,"Global", "Custom" )

[rweb95]

Yep, that worked! Thank you for your help!