Summing up different granularitys

[joshua1990]

Hello!

I am looking for a function/ approch for summing up the value on the lowest granularity for a whole family.

So, I have an ItemMaster like this:

Area	Article
1	XX
2	BB

Then I have a Fact Sheet with the Value per Article per Day

Date	Article	Value
01.01.2020	XX	5000
01.01.2020	BB	8200

And then I have a table with the Budget per Article (Article-Budget)

Now I want to calculate the difference between the Target and the Value per Item per Week.

This can be solved by an easy subtraction like [Target]-[Value].

Now I want to calculate the sum of all article per area, that are below Target.

And then I want to calculate the sum of all articles that are above Target.

How would you do that with a Dax Measure?

[Anonymous]

Well, I'm afraid you've given us a bit less info than needed. We'd like to see your data model.

[Anonymous]

hello, 
here is my small example, maybe it will help u  :