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
NazarBorodin
New Member

I have a problem with removefilter

I have this code:

Total Receipts Ignoring Amount Filter =
CALCULATE(
    DISTINCTCOUNT(Sales[Чек]),
    REMOVEFILTERS(Sales[Сума до сплати]),
    Sales[Сума до сплати] > 0
)
My task is to create a measure that will not react to the cutoff by [Сума до сплати]. But this measure still reacts to this cutoff. How can this be fixed?

2 REPLIES 2
sjoerdvn
Super User
Super User

If it is not linked to a dimension table (see previous comment), try using ALL instead of REMOVEFILTERS.

MattAllington
Community Champion
Community Champion

You need a dimension table for the column you are trying to remove. You cannot acheive the result you want by using REMOVEFILTER over a fact table. 

read my article here for what you should aim for. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

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.