Forum Discussion
A table of multiple values supplied for VALUES function
Hi Everyone,
I m getting this error " A table of multiple values supplied where single value is expected "
Dax i have written like this :
IF(SELECTEDVALUE(table(column)) = "Text", VALUES(table(column)), BLANK )
Can u pls help me on this ?
3 Replies
VALUES(table(column)) returns "An entire table or a table with one or more columns" - What are you trying to do here?
And are you creating a calculated column or a measure?
its a measure, i need to return value in card on filtering basis
OK, it's a measure.
"return value in card on filtering basis" - that's not really much to go on.
IF(SELECTEDVALUE(table(column)) = "Text",
VALUES(table(column)) <---- this part has to be a single result, i.e. an aggregation or a hardcoded resul
, BLANK )
