Switch True conditions for values in the same column but different rows
I am trying to use Switch True that would return a specific value is a particular customer has a certain combination of values (from the same column). However, a customer can have more than one row of data--meaning one value being on one row, and the other value on another row. I want to be able to determine whether or not each customer has the specified Code values from that column (though each Code value is on a different row for the same customer), and then return the appropriate resulting "Code Combination" value.
When I try the above approach with my actual data table, the new "Code Combination" column returns blanks. Any assistance is greatly appreciated.
Customer ID Code
Code Combination =
'Table'[Code] = "WBSA" && 'Table[Code] = "WMSA", "BS to MS")
Measure 2 = var a = CALCULATE(MAX('Table (3)'[Customer ID]),FILTER('Table (3)',[Code]="WBSA"))
var b = CALCULATE(MAX('Table (3)'[Customer ID]),FILTER('Table (3)',[Code]="WMSA"))
IF(a=b,BLANK(),"BS to MS")
Community Support Team _ Dina Ye If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.