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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Youplanetbi
New Member

Filter in a meassure not working properly

Good afternoon comunity,

 

I have a problem with a measure that is not aplying the filters that I look for

This is my data model

Youplanetbi_0-1729858039393.png


And I have two measures:

GF =
VAR ytod =
    CALCULATE (
        SUM ( '2024'[Valor] ),
        FILTER ( '2024', '2024'[Date] < DATE ( 2024, 10, 01 ) && '2024'[Date] >= DATE ( 2024, 01, 01 ))
    )
VAR forecast =
    CALCULATE (
        SUM ( FORECAST[Valor] ),
        FILTER ( FORECAST, FORECAST[Date] >= DATE ( 2024, 10, 1 ))
    )
RETURN
    forecast + ytod


And then when I apply this to another mesure it doesn't filter properly and gives me an incorrect greater number, this is the measure thai does not work as expected

Rev. Influencia = CALCULATE([Revenues 2024],FILTER('Dim_Area',Dim_Area[Area]="Influencia"))

Does anyone know what could be the issue






2 REPLIES 2
WishAskedSooner
Responsive Resident
Responsive Resident

Yikes! That is a really complicated Data Model with multiple relationships going every which way. I hope you understand it, but my instinct tells me you don't because you are having trouble de-bugging filtering issues which is almost gauranteed with such a complicated model. And what about the next problem, and the problem after that? Do you have a plan for how to quickly address those, or will you be always coming back here for help?

 

My first recommendation would be to simplify your model. You will probably think that is a waste of time. And maybe you're not building this Report for a Production environment, and you would be right. Or, maybe you don't know where to begin or how to simplify a data model. But, a a little (or a lot) of time invested now will eliminate more headaches than you can count down the road. Trust me; I speak from experience.

An don´t  see where you find this a complicated model.
If you pais a bit of attention instead of just critizice I focused on what is needed for this porpouse
2 dim tables 2 fact tables with correct relations between them 1 to many. The rest of the tables are not shown becasue is not necesary for the measures we are talking about. 
That you don´t understand when you see lines crossing does not mean that is a complicated model, I guess as you did, that you dont work with big datasets or with cubes. Worst quality response I got in this forum, but after checking how you respond to other users It does not suprise me.

Best of luck 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors