topic Re: Line plot with two measure in DAX Commands and Tips

Line plot with two measure

Anonymous — Mon, 30 May 2022 17:55:14 GMT

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

Re: Line plot with two measure

amitchandak — Tue, 31 May 2022 02:44:24 GMT

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?

Re: Line plot with two measure

Anonymous — Tue, 31 May 2022 19:55:19 GMT

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

Re: Line plot with two measure

v-easonf-msft — Thu, 02 Jun 2022 08:43:26 GMT

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