How to get summarize results that contains a value?

[sph1nkz]

This is the sample scenario and results

[SamInogic]

Hi @sph1nkz,

As per our understand you need to check if service type is MPLS, Radio, VSAT then Backup Status is equal to "Has Backup" And if service type is MPLS, but no Radio, VSAT then backup status is equal to "No Backup".

Create new Column with below DAX expression as shown in below,

Backup Status = IF('Table'[type]

IN {"MPLS","Radio","VSAT"} && 'Table'[Site Name]

in {"Site A Farm"},"has Backup","No Backup")

Below is the result :

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[rusgesig]

You need to group your row level (Site A/B) then return one value per row stating whether there is a backup or not. Your desired output table is inconsistent, as in that case MPL5 = both Backup and No Backup.
There are many ways to do it. You can group the Site Name column in query editor, choose SUM as the group function for your service type - it will return an error. 

In the formula bar, change 'sum' to 'Text.Combine' and add the seperator

Add a custom column with the following:

if Text.Contains([Count], "Radio") or Text.Contains([Count],"VSAT") then "Has Backup" else "No Backup")

this is your result, you can join new the table on the Site Name if you want.