Forum Discussion
How to return multiple measures
I've tried options and none working.. I'm still learning and cant use the 'if', lookupvalue or make any understanding of the links provided.
Please I'd need this help
How do you link the AMDR and Tx values? Are they in the same table? Are the "Tx" things values or measures?
You could try :
your_measure = IF(Values(B300_Ball[PHO])=" ADMTR:1"; AND("Tx1"; "Tx3";"Tx4"); IF(Values(B300_Ball[PHO])=" ADMTR:2"; AND("Tx3; Tx5")))
but maybe with "," instead of ";" (I have to use the semicolon so it just a habit of mine)
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
