display value for latest month selected in slicer

[Anonymous]

Hello dear Community, 

im have a date slicer, filtering for months. If multipile months are selected, I want to display my column value displayed for the lastest month. 

01        0,15

02        0,2

03        0,17

So, if a single month is selected, lets say 02, I want 0,2 to pop up. If all 3 months are selected, I wanna display the value 0,17. 

I highly appreciate any help & thanks in advance! 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You could create below measure and put it in a card visual. If no month is selected, it displays blank. 

Display Value = 
VAR _month = MAX('Table'[Month])
RETURN
IF(ISFILTERED('Table'[Month]),CALCULATE(SELECTEDVALUE('Table'[Value]),'Table'[Month]=_month),BLANK())

 

Or if you want to display value of the latest month when no month is selected, you could modify the measure into

Display Value = 
VAR _month = MAX('Table'[Month])
RETURN
CALCULATE(SELECTEDVALUE('Table'[Value]),'Table'[Month]=_month)

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Anonymous , Try a new measure like

measure =
var _max = maxx(allselected(Table), Table[month])
return
if(isfiltered(Table[month]), sum(Table[Value]), calculate(sum(Table[Value]), filter(Table, Table[Month] = _max)))