Scatter Chart Help for Evaluating Two Periods

Syndicate_Admin — Thu, 23 Feb 2023 13:11:11 GMT

Good morning

I have the following problem I would appreciate infinite help!

I have two period segmenters to compare two different periods.

In this case I have to visualize in a scatter plot the values of PRE AND POST OF TEMPERATURE AND HUMIDITY

Working with the following measures

PRE = CALCULATE(AVERAGE('ReadingsComfort'[READING]),USERELATIONSHIP('Period A'[Date],'ComfortReadings'[DATE]))

POST = CALCULATE(AVERAGE('ReadingsComfort'[READING]),USERELATIONSHIP('Period B'[Date],'ComfortReadings'[DATE]))

PRE for Humidity =

CALCULATE([PRE], 'Meter monitoring'[PROBE] IN { "Humidity" })

PRE for Temperature =

CALCULATE([PRE], 'monitoring counters'[PROBE] IN { "Temperature" })

POST for Humidity =

CALCULATE([POST], 'meter monitoring'[PROBE] IN { "Humidity" })

POST for Temperature =

CALCULATE([POST], 'meter monitoring'[PROBE] IN { "Temperature" })

And I'd like to represent them in such a way that I can compare them on a scatter plot, sort of like that.

It would be possible???????

I would appreciate any help from me!!!!!!

Thank you very much.

topic Scatter Chart Help for Evaluating Two Periods in DAX Commands and Tips