Max Date issue when using as visual filter

[Anonymous]

Hi everybody,

sorry if the question has already been asked in a similar way. During the search I found it difficult to describe the problem concretely.

My customer has the following scenario , which I tried to recreate using simple dummy data:
We have different orders that are either active or inactive in a period of time. The Sales table provides sales per order and date, the ActiveDisplay provides information whether the order is active at time x or not. Both tables have a relationship via the OrderSk.

Now I want the sum of the sales per year for all active orders.

I create 2 measures for this

So far so good, but now I get a different year total depending on the filtered year. If I filter by 2021, the Measure checks if the order is active in 2021 so it gives me the correct total. But if I filter by 2021 and 2022, I get a different total for 2021 as the measure correctly checks the max date, which then is 2022.

How do I get the active check per year within a measure? I do realize that in my dummy case it is possible to simple filter the active order by the column of the ActiveDisplay table.  But this is not possible in the real case as the measure is needed for additional requirements.

Any help or suggestion would be really much appreciated

Thank you

[Greg_Deckler]

@Anonymous Can you post sample data as text?

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.