Forum Discussion

Dusha's avatar
Dusha
Regular Visitor
8 years ago
Solved

Filters/slicers over calculated (average) values in line chart

Hi all, Great community, I was able to find almost all solutions and answers to the questions I've had. But the one remains whcih I am struggling to deal with.   I have a simple table like below ...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Dusha,

 

You may research the code generated by Quick measure Running total.

Dusha's avatar
Dusha
Regular Visitor
8 years ago

Great tip, thanks, I have just created 'Running total' using 'quick measure' against 'R.Period' and it worked!

All filters are working now.

 

Value running total in R.Period = 
CALCULATE(
 SUM('Table'[Value]),
 FILTER(
 ALLSELECTED('Table'[R.Period]),
 ISONORAFTER('Table'[R.Period], MAX('Table'[R.Period]), DESC)
 )
)