Hello, I am trying to capture the running total captured here:
Running_Total_by_AccessAndDate =
VAR CurrentAccessType =
SELECTEDVALUE('PING_USER_SIGNON_NEW (2)'[useraccesstyp])
VAR CurrentMonth =
MAX('Calendar'[YearMonthNumber])
RETURN
CALCULATE(
COUNTROWS('PING_USER_SIGNON_NEW (2)'),
FILTER(
ALL('Calendar'),
'Calendar'[YearMonthNumber] <= CurrentMonth
),
'PING_USER_SIGNON_NEW (2)'[useraccesstyp] = CurrentAccessType
)
However, this is not working properly. As it is not giving me the correct outputs. The outputs are much lower than expected.
I have a date table called Calender than has date, month_year_label (Mar-25), and YearMonthNumber (202501). Then I have my user sign on table. That I am connect to the date table on YearMonthNumber to Yearmonth in the user sign on table that is also number format (202501).
This measure was working when I had no date table being used that was connected to it for reference:
Running_Total_by_AccessAndDate 3 =
VAR CurrentAccessType = SELECTEDVALUE('PING_USER_SIGNON_NEW (2)'[useraccesstyp])
VAR MaxDateInContext = MAX('PING_USER_SIGNON_NEW (2)'[CREATEDATE])
VAR MinDateInContext = CALCULATE(MIN('PING_USER_SIGNON_NEW (2)'[CREATEDATE]), ALL('DIM_DATE'))
RETURN
CALCULATE(
COUNTROWS('PING_USER_SIGNON_NEW (2)'),
FILTER(
ALL('PING_USER_SIGNON_NEW (2)'),
'PING_USER_SIGNON_NEW (2)'[useraccesstyp] = CurrentAccessType &&
'PING_USER_SIGNON_NEW (2)'[CREATEDATE] <= MaxDateInContext
),
VALUES('DIM_DATE'[year_month_number])
)
