Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
6 years ago

Summing up different granularitys

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:

AreaArticle
1XX
2BB

 

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

DateArticleValue
01.01.2020XX5000
01.01.2020BB8200

 

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?

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

     

     

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