Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
filipbobczuk
Frequent Visitor

Measure to ignore filters

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? 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

6 REPLIES 6
Idrissshatila
Super User
Super User

@filipbobczuk ,

 

try using this

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


Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

Anonymous
Not applicable

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

That worked, thanks!

Idrissshatila
Super User
Super User

Hello @filipbobczuk ,

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors