Measure to ignore filters

[filipbobczuk]

Hey,
I have an issue with the measure. I want to display it in a card visual at the top of my report, it has to be all time which means not affected by 'Dates' filters or slicers.

CALCULATE(
	[Potential Patients],
	REMOVEFILTERS('Dates'),
	FILTER( 'Patient Sales Deals', NOT ISBLANK( 'Patient Sales Deals'[Won Date] ) )
)

In the "filters on this page" I need to add 'Dates'[Date] filter to restrict my other visuals on the report but unfortunately whenever I change the date period in the filter my initial visual gets affected and the values change.

How to fix it? 

[Idrissshatila]

@filipbobczuk ,

try using this

CALCULATE(
	[Potential Patients],
	ALL('Dates'),
	FILTER( 'Patient Sales Deals', NOT ISBLANK( 'Patient Sales Deals'[Won Date] ) )
)

[filipbobczuk]

Hey,
I have tried it but it is still not working.

[Anonymous · Accepted solution]

Hi @filipbobczuk ,

Please try:

Measure = 
CALCULATE(
	[Potential Patients],
	ALL('Dates'),
	NOT ISBLANK( 'Patient Sales Deals'[Won Date] )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[filipbobczuk]

That worked, thanks!

[Idrissshatila]

Hello @filipbobczuk ,

can you attach your pbix file so we could check it ?

[filipbobczuk]

Unfortuantely not as it contains business data, but I will be glad to provide any necessary info if needed.