Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

How to return multiple measures

Need Help
lattys's avatar
lattys
Frequent Visitor
9 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        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