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.
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!
Solved! Go to Solution.
@rweb95 , Try a new column like
if(countx(filter(table, [UtilityName] =earlier([UtilityName] ) && isblank([CompanyId])),[UtilityName])+0>=1,"Global", "Custom" )
@rweb95 , Try a new column like
if(countx(filter(table, [UtilityName] =earlier([UtilityName] ) && isblank([CompanyId])),[UtilityName])+0>=1,"Global", "Custom" )
Yep, that worked! Thank you for your help!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |