Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Clalculated column not displaying right

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.

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous 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")

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous 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")