Multiple Sections or Select All in Filter Slicer Not Displaying Column Values

Hi  Palan22  ,

According to your description, I create some data:

Here are the steps you can follow：

1. Create calculated table.

Service = CALENDARAUTO()

2. Create calculated column.

Month = FORMAT('Service'[Service Date],"mmm")

Month = FORMAT('Goals'[Goal Date],"mmm")

3. Create measure.

Target Goal Per Month =
var _select=SELECTEDVALUE('Service'[Month])
return
CALCULATE(MAX('Goals'[DOS]),
FILTER(ALL('Goals'),'Goals'[Month]= _select && 'Goals'[Status] = "Completed"))

4. Put [Status] in Filter and select Completed

5. Result:

When choosing ALL,

When choosing May,

If this result does not meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

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