Displaying a running total on a card

[eddd83]

In my table, X-High, High, Medium and Low are all measures. Total is just a measure summing the previous 4 measures. All-running total is the running total for the first 4 measures, while X-high + high running total is just the running total for X-high + high.

Is there a way of displaying the final value (21 & 10) for both "all running total" and "x-high + high running total" on a card like so......

Here are the running total measures if it helps

All Running Total =
SUMX (
    FILTER (
        ALLSELECTED ( 'Date'[Date] ),
        'Date'[Date] <= SELECTEDVALUE ( 'Date'[Date] )
    ),
    'Report Measures'[Total]
)

X-High + High Running Total = 
SUMX (
    FILTER (
        ALLSELECTED ( 'Date'[Date] ),
        'Date'[Date] <= SELECTEDVALUE ( 'Date'[Date] )
    ),
    'Report Measures'[High] + 'Report Measures'[X-High]
)

[eddd83 · Accepted solution]

Ok. I managed to figure out a halfway solution. If I use a bar chart and change to a date hierarchy, I get the result that I want.

BTW, how do i upload an image in the reply? I entered the url for the image, and it just gves an "X". and there's no option in "insert/edit image" to scan my PC for the picture.

[AlB]

Hi @eddd83 

Try changing

SELECTEDVALUE ( 'Date'[Date] )

for

MAX ( 'Date'[Date] )

in both measures. SELECTEDVALUE will by default return NULL when more than one date is present in the filter context. You could also do:

SELECTEDVALUE ( 'Date'[Date] ,  MAX ( 'Date'[Date] ) )