Return depending on number of selected column from slicer

[lynnsop]

Hi People.

I need a measure doing the following depending on what I select on a slicer:

When I select multiple values: Return "Multiple"
When I select no value: Return "No"

When I select a single value (1): Return Last Date

Column which gets filtered in slicer:

2021-01

2021-02

2021-03

I have created the following measure for this:

Measure23 =

Switch(true() ,

not(isfiltered('KPIs Summary'[Actual Date])) , "",

countx(allselected('KPIs Summary'[Actual Date]), 'KPIs Summary'[Actual Date]) >1 ,"From Selected Dates", LASTDATE('KPIs Summary'[Actual Date]))

This seems to work except for the marked part. It gives me the following result instead of 2021-03:

Do you have an solution or new measure for this?

[V-lianl-msft]

Hi @lynnsop ,

Is this problem has been solved?

If the problem persists, please share a sample pbix with dummy data.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lynnsop]

Hi @V-lianl-msft 

I found a workaround for that so I dont have to use that "complex" DAX. Thanks for your help and time! 🙂

[V-lianl-msft · Accepted solution]

Hi @lynnsop ,

I checked your formula, there is no problem in import mode. It should be noted that the [Actual Date] column needs to be in date format.

If your data source connection mode is direct query, it may cause this problem. It is recommended that you rewrite measure as:

Switch(true() ,

not(isfiltered('KPIs Summary'[Actual Date])) , "",

countx(allselected('KPIs Summary'[Actual Date]), 'KPIs Summary'[Actual Date]) >1 ,"From Selected Dates", SELECTEDVALUE('KPIs Summary'[Actual Date]))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@lynnsop , Try if that can help

countx(allselected('KPIs Summary'[Actual Date]),filter( 'KPIs Summary', 'KPIs Summary'[Actual Date] >1 && 'KPIs Summary'[Actual Date] = LASTDATE('KPIs Summary'[Actual Date])))

or

meausre =

var _max = maxx(allselected('KPIs Summary', 'KPIs Summary'[Actual Date])
return
countx(allselected('KPIs Summary'[Actual Date]),filter( 'KPIs Summary', 'KPIs Summary'[Actual Date] >1 && 'KPIs Summary'[Actual Date] = LASTDATE('KPIs Summary'[Actual Date])))

[lynnsop]

Hey @amitchandak thanks for your answer. 

Unfortunately both measure do not seem to work.

1st:

2nd:

[amitchandak]

@lynnsop , Sorry, My mistake.

Try if these can work

countx(filter(allselected('KPIs Summary'[Actual Date]), 'KPIs Summary'[Actual Date] >1 && 'KPIs Summary'[Actual Date] = LASTDATE('KPIs Summary'[Actual Date])),
'KPIs Summary'[Actual Date])

measure =

var _max = maxx(allselected('KPIs Summary', 'KPIs Summary'[Actual Date])
return
countx(allselected('KPIs Summary'[Actual Date]),filter( 'KPIs Summary', 'KPIs Summary'[Actual Date] >1 && 'KPIs Summary'[Actual Date] = LASTDATE('KPIs Summary'[Actual Date]))
, 'KPIs Summary'[Actual Date])

[lynnsop]

@amitchandak 
Still not working 😞

1st is just showing me the amount of filters I selected regardless of if i combine it with my switch:

2nd:

Even when I fix the ) in MAXX Function