Display Highest Value on Card using Filter

[littlepatos]

I would like to display highest value, filtered by category (Activity Type) to only show Walking (Activity Type) and display as Distance & Month. Therefore card value would change depending on which Month I walked the highest number of Distance. Eg: Expected Result: January 94

I've tried to create a measure but unsure how to add Filter to only display Activity Type Walking

Distance max per Month =

MAXX(

SUMMARIZE(Activities,Activities[Distance]

),[Measure]),allselected())

Activity Type                            Date                          Distance

Strength Training	31/12/2022	0
Yoga	31/12/2022	0
Elliptical	31/12/2022	0
Kayaking	30/12/2022	1.74
Strength Training	29/12/2022	0
Yoga	29/12/2022	0
Walking	29/12/2022	4.21
Strength Training	28/12/2022	0
Yoga	28/12/2022	0
Indoor Cycling	28/12/2022	0
Strength Training	27/12/2022	0
Yoga	27/12/2022	0
Walking	27/12/2022	3.82
Strength Training	26/12/2022	0
Yoga	26/12/2022	0
Elliptical	26/12/2022	0
Yoga	24/12/2022	0
Indoor Cycling	24/12/2022	0
Walking	23/12/2022	5.29
Yoga	21/12/2022	0
Walking	21/12/2022	5.26
Walking	20/12/2022	5.06
Yoga	18/12/2022	0
Indoor Cycling	18/12/2022	0
Pool Swimming	17/12/2022	700
Strength Training	17/12/2022	0
Yoga	17/12/2022	0
Walking	17/12/2022	4.9
Yoga	11/12/2022	0

[littlepatos]

Hi @Ashish_Mathur Thanks for your assistance. 

1) Max distance travelled in any month - Correct and working as expected

2) Period of Max Distance Travelled is showing December which is the highest before applying filter to show only Walking. How can I add filter to Measure to only show walking? 

Any ideas where i may be going wrong?

[Ashish_Mathur]

You are welcome.  Unless i see your file, I cannot comment.  Share the download link fo the PBI file and show the expected result.  Ensure that in the slicer, you select Walking.

[littlepatos]

All good- I worked out how to add filter to the visual.  Thanks again for your help.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.