Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 ?
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 )
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 64 | |
| 47 | |
| 41 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 184 | |
| 123 | |
| 106 | |
| 78 | |
| 52 |