Clalculated column not displaying right

[ExcelPBI]

Hi community,

Following is my sample dataset:

I want to create 2 columns Result1 & Result2.

Result1 = if the client has value 1 then True

Result1 = if the client has value 3 then True

I want result1 & result2 to look like following in the matrix:

Sample file:  https://1drv.ms/u/s!Ag919_pO_UKrgS4axMQY6IFFpowi?e=gIEbYl

Thanks in advance.

[Greg_Deckler · Accepted solution]

@ExcelPBI Perhaps:

Result1 Measure =
  VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
  IF( 1 IN __Values,"TRUE","FALSE")

Result2 Measure =
  VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
  IF( 3 IN __Values,"TRUE","FALSE")