cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

cumulative count

Good, hoping you are well.

I would like to know how I can generate a cumulative measure, I have two tables, one of users with the date on which they registered and another of the calendar, I would like to know how I can count and accumulate to see the increase of users per day based on the calendar table, example:

Users table:

 User Register Loud Usuario1 1 01/01/2021 usuario2 1 01/05/2021 usuario3 1 01/03/2021

Calendar table:

 Date Month week Day 01/01/2021 1 1 1 02/01/2021 1 1 2 03/01/2021 1 1 3 04/01/2021 1 1 4 05/01/2021 1 1 5 06/01/2021 1 1 6 07/01/2021 1 1 7 08/01/2021 1 2 1 09/01/2021 1 2 2

Matrix to be generated:

 01/01/2021 02/01/2021 03/01/2021 04/01/2021 05/01/2021 06/01/2021 07/01/2021 1 1 2 2 3 3 3

I tried the following but it goes wrong:

Count =
was totalA=
CALCULATE(SUM(agent[Register]),
FILTER(
ALLSELECTED(Calendar[Date]),ISONORAFTER(Calendar[Date],MAX(Calendar[Date]),DESC)))
return IF(ISBLANK(totalA),0,totalA)

Best regards

Super User

@Syndicate_Admin , measure seem fine. Make sure calendar is connected  agent on the date.

Try one of the two

CALCULATE(SUM(agent[Register]),
FILTER(
ALLSELECTED(Calendar[Date]),Calendar[Date]< = MAX(Calendar[Date])))

or

CALCULATE(SUM(agent[Register]),
FILTER(
ALL(Calendar[Date]),Calendar[Date]< = MAX(Calendar[Date])))

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.