Dynamic Max Jauge with slicer date

[Vahks]

Hello,

I am trying to create a gauge with a dynamic maximum, which can only be influenced by a date slicer, I do not want my other Nature Slicer that you will see in my example below to be able to influence the maximum.

I am attaching an example : Here 

I tried several formulas but it didn't work.

Someone can help me please ?

Thanks

[v-junyant-msft]

Hi @Vahks ,

Have you solved your problem?
If not, please try this way.
Use this column to build a new table without any relationships:

Use this DAX to create a measure in the new table I build just now and put it into the Maximun value of the Gauge:

Test1 = 
CALCULATE(COUNT('Slicer'[Created_At]), FILTER('Slicer', 'Slicer'[Created_At] >= MIN('Calendar'[Dates]) && 'Slicer'[Created_At] <= MAX('Calendar'[Dates]) ))

The final output is as below:

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

[Ashish_Mathur]

Hi,

Turn Off interactions.

[Vahks]

Hi Turn off interactions doesn't work because i don't need to fix the value, only the max value of the gauge when i click on the other filter.

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.