Can't get current value on Power BI dashboard.

[danielns_98]

Hi everyone. First of all I wanna say that I am very new on Power BI and I've been searching help on this community and I think that it is a very good one. 

So: I want to create a dashboard on Power BI to see real time data, comming from my Azure IoT Hub. These data are Temperature, pressure, hydrogen and date values, and they are being send every 5 seconds.

So, what I've done to get current value is create the following new measure:

The problem is that it sometimes shows the current temperature value,

but most of the time it doesn't (it shows a message which says "in blank").

If i make a table to see temperature, current temperature and date, I get this:

So it looks like most of the time the measure is not being calculated and in some random cases it is. 

Does anyone know how can I solve that? 

Thank you!

[v-kkf-msft]

Hi @danielns_98 ,

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @danielns_98 ,

Because the data can be refreshed normally, I think that you don't use a measure.

Change the type of the TEMPERATURE column to Text format (if other places need to summarize the column, you need create a copy).

Then use the Card visual and choose to display the last value.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[HarishKM]

@danielns_98 Hey Mate ,

Try this .

Temp1 = CALCULATE(MAX(Test[Temp]))

output will be 

[v-kkf-msft]

Hi @danielns_98 ,

Try the following formula:

Current Temperature = 
CALCULATE(
    MAX(PBITableDeDatos[TEMPERATURE]),
    FILTER(
        PBITableDeDatos,
        PBITableDeDatos[DATE] = MAXX(ALL(PBITableDeDatos),PBITableDeDatos[DATE])
    )
)

Do the tiles on the dashboard individually pin visuals in the report, or pin a live page?

Try pin it separately from the card view that displays this measure.

If it still displays Null, I think the refresh interval maybe too short, measures have no time to calculate the result.

Try to set the refresh time to 2 minutes to see if the output is correct.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[danielns_98]

Hi, I tried the formula and it does the same has the one I used. It only calculate some values, the rest gets blank, not calculated.

The data is send from my PLC, I've changed the time that the PLC send the values from 5 seconds to 2 minutes and doesn't work either, so is not that the measure have no time to caculate the result... I am not doing the tests in the dashboards directy, I am doing it on the report  and I am clicking refresh every 30 secons or so.

[selimovd]

Hey @danielns_98 ,

that seems to be because most of the time the column PBITablaDeDatos[TEMPERATURE] is blank, so you get a blank result.

Try the following measure:

Current Temperature =
CALCULATE(
    VALUES( PBITablaDeDatos[TEMPERATURE] ),
    PBITablaDeDatos[DATE] = MAX( PBITablaDeDatos[DATE] ),
    PBITablaDeDatos[Current Temperature] <> BLANK()
)

I think the Filter function you won't need, this way has a little better performance. It's ignoring the rows where the temperature is empty.

Please next time post the measure in text and not just as a picture, it's not fun to copy the formula from a screenshot.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[danielns_98]

Hi, thanks for your quick reponse!

The column PBITablaDeDatos[TEMPERATURE] has not blank spaces, the column which is blank most of the time is PBITablaDeDatos[Current Temperature], which is the one that I've created with the new measure. Actually, the column PBITablaDeDatos[TEMPERATURE] has a new value every 5 seconds.

So, in fact, this is what I am trying to understand: Why does the new measure Current Temperature creating that many blank spaces on his column PBITablaDeDatos[Current Temperature], instead of calculating the value?

The way I've done it has being copied from a youtube video of a man who did almost the same dashboard as me, so it should work this way... So maybe the problem is something about my Power BI configuration...

However, I've tried your measure and it hasn't worked. It gives an error which says "Cannot find name '[Current Temperature]'", I suposse that it is because Current Temperature is the measure that is being defined on the new measure.

Again, thank you very much, and sorry for posting the dax formula as a picture.

[selimovd]

Hey @danielns_98 ,

OK, I slowly start understanding more 😉

Try the following measure:

Current Temperature =
CALCULATE(
    MAX( PBITablaDeDatos[TEMPERATURE] ),
    PBITablaDeDatos[DATE] = MAX( PBITablaDeDatos[DATE] )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[danielns_98]

Still doesn't work 😥