Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Line plot with two measure

Hello, I have create two measure with the following DAX:

Dynamic indes:

Index_Measur 2 =
CALCULATE (
COUNTROWS ( Tabelle1 ),
FILTER ( ALLSELECTED ( Tabelle1 ), Tabelle1[Faktor 1] < MAX ( Tabelle1[Faktor 1] ) )
)

and a moving average
 
Moving Average_Measure IndexMeasure =
VAR Window_A = 10
VAR myResult =
SUMX(
FILTER(
Tabelle1,
Tabelle1[Index_Measur 2]> Tabelle1[Index_Measur 2]-Window_A &&
Tabelle1[Index_Measur 2] <=Tabelle1[Index_Measur 2]
),Tabelle1[Wert]
)
RETURN CONVERT(myResult/Window_A,DOUBLE)
 
My simple question:
How can I visually represent the data in a (e.g. line plot)?
 
 Thank you
 

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You can use them both on Y-axis/Values in a line visual. If you need a single value for one line then you can use that in the analytics pane Constant Line - > Fx.

     

    What is the challenge you are facing when you add two measures?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The problem is that I cannot drag the measure onto the x-axis or y-axis. They are not accepted by the visual.

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Anonymous 

        Currently you cannot place measure fields on axixs.

        If possible, please try creating a new table or calculated column.

         

        Best Regards,
        Community Support Team _ Eason