Forum Discussion
How to return multiple measures
Tx(1-5) are Measures and the ADMTR:1 and ADMTR:2 is in another table.
I've tried your options and I get lots of errors on the DAX expression.
Please I'd need this help
Hi Anonymous,
You can open Query Editor, add a index column like below:
Then create a calculated column use Switch() function:
STATION = SWITCH([Index],1,Tx1 ,2,Tx2,3,Tx3,4,Tx4,5,Tx5)
Best Regards,
QiuyunYu
Hi Anonymous,
I have go through your pbix file, I find those measures Tx1, Tx2,...Tx6 use the same formula =SUM(A2011_ConfigData[DataValueDelta])*1
Is there any reason that you create so many same measures?
Besides, the Station is blank so the slicer doesn't have any values. You define the calculated column to return different results with more than one same condition, eg: when [Index] =1, return Tx1, Tx2, Tx3, it makes confusion so no values returned. As those measures use same formula, you can just create a Station column with [Tx1] t return data.
Best Regards,
Qiuyun Yu