undefined

[Syndicate_Admin]

Good community!!!

I am trying to create a MEASURE or COLUMN to display on a card the average value of the last hour. I know, that in a table organizing the hierarchies of Date and Time I can show it. But I want to show the value directly on a card, without the need to apply filters, something like the average value of the last hour in real time.

In the following table I specify the following data:

Apply an averange and I arrive at the expected result by applying from a filter panel the selection of the date and time. But the idea is that by default and without applying filters the card can show me the values.

Those would be the expected values, but without having to apply filters.

Currently I am only applying an AVERANGE, but I do not know how to specify that I calculate the last minute value. Taking as a sample the four registers hs.

Prom EJE3 = CALCULATE(AVERAGE('f_ejemplo'[EJE3]))

I leave the pbix file so they can look at the data and measurements.

https://drive.google.com/drive/folders/1KC5jCHSkqYPCifytcHjuIoZ7eH253Bps?usp=sharing

Best regards!

I await your comments.

Best regards!!!

[v-yanjiang-msft · Accepted solution]

Hi @Syndicate_Admin ,

According to your description, I download your sample, here's my solution.

Create a measure.

Promedio_Nivel = 
CALCULATE (
    AVERAGE ( muestra[Nivel_1] ),
    FILTER (
        ALL ( 'muestra' ),
        HOUR ( 'muestra'[Fecha_Hora] )
            = MAXX ( ALL ( 'muestra' ), HOUR ( 'muestra'[Fecha_Hora] ) )
    )
)

Get the correct result without a slicer.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , if you have datetime column, you can create a measure like

calculate( Count(Table[Value]), filter(Table, Table[Datetime] >= now() -time(1,0,0) && Table[Datetime] < now() ) ) 

[Syndicate_Admin]

Dear.

Thanks for the help. But it didn't work.

The expression

EXAMPLE =

CALCULATE(COUNT('f_ejemplo'[EJE3]), filter('f_ejemplo', 'f_ejemplo'[Fecha_Hora] >= now() -time(1,0,0) && 'f_ejemplo'[Fecha_Hora] < now() ))

It throws blank vlaroes at me.

Nose if I should put the YTD.

I await comments. Best regards.