Forum Discussion

audstrich's avatar
audstrich
Regular Visitor
7 years ago
Solved

DAX help

Hi everyone,   I would like to get one of three outputs from the expression that I am hoping someone can teach me about: trial, implant, or battery replacement. Two of these outputs are very simple...
  • parry2k's avatar
    parry2k
    7 years ago

    audstrich add new column in your table using following expression

     

    Output 2 = 
VAR __data = CALCULATETABLE( VALUES(Table8[Code]), ALLEXCEPT( Table8, Table8[ID Number] ) )
RETURN
IF( Table8[Code] IN {"63650","63685" },
    SWITCH( TRUE(),
        "63650" IN __data  &&  NOT "63685"  IN __data , "Trial",
        "63685" IN __data  &&  NOT "63650"  IN __data , "Battery Replacement",
        "63685" IN __data  &&      "63650"  IN __data , "Implant"
    )
)
parry2k's avatar
parry2k
Super User
7 years ago

Are you adding a measure or column?

audstrich's avatar
audstrich
Regular Visitor
7 years ago

Column.

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Hmmm, not sure why it will give an error message when it is column, can you test it on sample dataset you provided, it all worked fine for me

     

    • audstrich's avatar
      audstrich
      Regular Visitor
      7 years ago

      The Home Table was wrong! It works beautifully now. Thank you so much!! I really appreciate it.

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Woo hoo, glad to hear.