How to show maximum value of guage visualize in specific slicer?

[ULtimateG]

Hello, I have been trying to use a Gauge chart to show the summarized data for each week using Slicer. The problem is
1. (Picture 1) Gauge show x2 of Data (356) instead of 178
2. (Picture 2) When I filter dates and category it can't show summarized data of each category in gauge, but show only the filtered value. I want to show 131 / 178

In this picture, gauge show 178 of 356 Data

 Is there a way to be able to solve this problem?

DateCategoryData

19/7/2566	A	1
20/7/2566	A	3
25/7/2566	B	4
26/7/2566	C	5
27/7/2566	A	6
28/7/2566	A	7
28/7/2566	B	4
28/7/2566	A	10
29/7/2566	C	3
1/8/2566	A	50
3/8/2566	B	30
4/8/2566	A	70
4/8/2566	A	1
4/8/2566	B	5
4/8/2566	C	3
4/8/2566	B	9
4/8/2566	A	10

[Anonymous · Accepted solution]

Hi, @ULtimateG 

You can try the following methods.
Measure:

Max = CALCULATE(SUM('Table'[Data]),FILTER(ALL('Table'),[Date].[Month]=SELECTEDVALUE('Table'[Date].[Month])))

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

[ULtimateG]

This solution works fine, thanks.