Forum Discussion

bhavnachalise15's avatar
bhavnachalise15
Frequent Visitor
2 years ago

Rolling Total Measure Showing Correct Values in Table and Line Graph But not on Card and Tooltip

I have created a rolling total measure -

RT =
VAR _EndDate = MAX(dimCalendar[Period])
VAR Amt =
CALCULATE(
    Count Measure,
        FILTER(
             ALLSELECTED(dimCalendar),
                dimCalendar[Period] <= _EndDate
))
Var Final = IF(ISBLANK(Count Measure),BLANK(),Amt)
RETURN
Final
 
This measure works perfectly fine for Graphs and Tables but not in a Card and similarly doesn't work for Tooltip

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Icon for Super User rankSuper User
    2 years ago

    Hello bhavnachalise15,

     

    Can you please try modifying the measure for tooltip compatibility:

    RT =
VAR _EndDate = 
    IF(
        HASONEVALUE(dimCalendar[Period]), 
        MAX(dimCalendar[Period]), 
        LASTDATE(dimCalendar[Period])
    )
VAR Amt =
    CALCULATE(
        Count Measure,
        FILTER(
            ALLSELECTED(dimCalendar),
            dimCalendar[Period] <= _EndDate
        )
    )
Var Final = 
    IF(ISBLANK(Count Measure), BLANK(), Amt)
RETURN
Final

     Should you require any further assistance, please do not hesitate to reach out to me.