Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Anonymous customers

I have a field within my data that represents a true and false value if a customer wants to be anonymous, I need an IF function that would search for the value of this field and replace the customer name to annoymous if the field is true. If not true, then leave customer name. 

 

Any help on this?

Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    Anonymous 

    you can utilize a measure like this

    Measure = 
MAXX (
    ADDCOLUMNS (
        ADDCOLUMNS (
            'Table',
            "X", SWITCH ( TRUE (), 'Table'[Condition] = TRUE (), 1, 0 )
        ),
        "change", SWITCH ( TRUE (), [X] = 1, [name], "anonymous" )
    ),
    [change]
)

     

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,

    a new column

    = if([field] = true(), "annoymous ", [Customer])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It's saying that the DAX cannot values of type Text to True/False. Consider using Value or Format. 

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

    Anonymous 

    you can utilize a measure like this

    Measure = 
MAXX (
    ADDCOLUMNS (
        ADDCOLUMNS (
            'Table',
            "X", SWITCH ( TRUE (), 'Table'[Condition] = TRUE (), 1, 0 )
        ),
        "change", SWITCH ( TRUE (), [X] = 1, [name], "anonymous" )
    ),
    [change]
)

     

     

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

      Anonymous  did you try the above?