Forum Discussion
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...
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" ) )
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"
)
)
Thank you so much! But it's still not working. I get this error:
A single value for column 'Code' in table 'Table 8' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
When I add COUNT to the formula, I get this error:
Function 'CONTAINSROW' does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.