Count Filtered Table

[lucasbhering]

I need to count how many people are in this filtered table, both for people and visitors, my most recent filter, needs to update to NOW () on DAX automatically. How can I do this?

[lucasbhering]

Measures:
TOTAL COLABORADORES = CALCULATE(COUNTROWS(PESSOA);AREA[CD_AREA] == 2)

TOTAL VISITANTES = CALCULATE(COUNTROWS(ACESSO_VISITA);ACESSO_VISITA[CD_AREA] == 2)

HOJE = NOW()
(however it does not update in real time.)

[lucasbhering]

I managed to do the DAX, go up with the gateway in the direct query, however I put the schedule to update every 15 minutes, it usually occurs on the panel, but when I published on the public web, there is no update of the direct query every 15 minutes only every 1 hour.

[v-lid-msft]

Hi @lucasbhering ,

For Published to Web, based on this document,  Data refreshes are automatically reflected in your embedded report or visual. It can take approximately one hour for refreshed data to be visible from embed codes.

But if you share a report, When opening an existing report in the Power BI service, or authoring a new one, the underlying data source is again queried to retrieve the necessary data. Please refer to this document about Guidance for using DirectQuery successfully: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

We can tried to share a report or dashboard by using Embed in security website or Share within Power BI Service/ Apps if you want to make it update more frequently. 

Best regards,

[lucasbhering]

Hello v-lid-msft I need my panel to be updated at least every 2 minutes, that is, to force an update in DirectQuery and transmit the panel to a cromecast device is this possible? How does this Power BI Service / Apps process work?