Filter only with a slicer date don't work

[Vahks]

Hello,

I tried several methods and did several searches but without success.

Here is my problem :

All data comes from a single source table.

I have a date field ( Table[Date] ) integrated into a slicer :

I want to count the number of dates dynamically between the two date when I move the slicer but I don't want another filter to be able to modify the result.

I tried this dax (and many others!):

Measure = CALCULATE ( 
 COUNT( Table[Date] ), 
 REMOVEFILTERS ( 'Table' ), 
 VALUES(Table[Date]) 
)

Here is the result :

404 seems to be the right number of date between the two dates selected. I don't know why the figures for each Value are not the sum of the total.

 But when I click on a filter

You can see that the total is not correct because I don't want the segment filter to change the number of dates corresponding to the chosen date range.

How can i avoid that ?

Thanks for help !

[Anonymous]

Hi @Vahks 

I did a test that may help you.

My sample:

Measure:

sum = CALCULATE(COUNT('Table'[Date]), FILTER('Table', [Date] >= MIN('Date'[Date]) && [Date] <= MAX('Date'[Date])))

Is this the result you expect?

If I've misunderstood you, please provide detailed sample data: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,

Community Support Team _Yuliax

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

[Vahks]

Hello,

Nobody have an idea ? 🙂

Thanks

[Vahks]

Hello,

Thanks for this but it's not this that i need 🙂

I share a pbix with you, i just need to fix the max value from a Jauge like this :

When i select 5 June 2023 to 5 November 2023, i have 495, so i want the 495 is fixed with the selection of the slicer date but if I click on the visual filter like above on Filter 1, the Jauge is update like this :

The max change with 487 but i want the max at 495, i share you my sample report here : https://drive.google.com/file/d/1awaSMnkSWXqsMyWzf9lgWbhKroM5W7hy/view?usp=sharing 

Thanks for help !

[Anonymous]

Hi @Vahks 

I would like to apologize for the belated reply.

Since I can't get the data through the link you gave, I'll give you an idea over here.

You can fix the maximum value of visual with the button shown in the screenshot.

For more details, you can read related document link:

Radial gauge charts in Power BI - Power BI | Microsoft Learn

Best Regards,
Community Support Team _Yuliax

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 interaction between the Segment filter and the visual.

[Ritaf1983]

Hi @Vahks 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Vahks]

Hello,

Thanks for this, i have share above a sample report and i explain more the context !

Thanks