cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## How to show the last value in multi select slicer

Hello all
I have a problem, hope you guys can help
So I filtered by company and month to get an actual revenue.
Example:
If I want to filter [company 1] in February, the value will appear on the card. Furthermore, if I filter [company 1] with muti select in February and March, the card will only display the last value selected, which is March. So for the next. So whatever is selected, I just want to display the last actual value that was selected.

I have a problem because every time I do a multi select, then the value will be summed. But I only want to display the last selected value, not sum it up when i multi select the month

1 ACCEPTED SOLUTION
Super User

Hi,

You may download my PBI file from here.  I have selected Feb, Mar, Apr in the Month slicer

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
7 REPLIES 7
Frequent Visitor

How to return the Sum for the last item selected in the slicer? My data does not use Calendar or include Months or Date Values.

Super User

Hi,

You may download my PBI file from here.  I have selected Feb, Mar, Apr in the Month slicer

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper I

Thank you for helping @Ashish_Mathur

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@PowerVisualBI , make sure you also have month no(numeric) in your table.

then create a measure like

= var _max = maxx(allselected('Date') , 'Date'[Month])

return

calculate(sum(Table[Value]), filter('Date', 'Date'[Month] =  _max))

Helper I

Hello the greate user @amitchandak
I'm using the measure, not calculated column. So, calculate(sum(Table[value]), can't be used because it can only read calculated column in that condition, not with measure.
Maybe you can open my file first
Thank you

Helper I

Hello mr @amitchandak
Looks like you failed to understand what I mean sir
This even creates an error. Maybe you can open my file first
Thank you

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors