Forum Discussion
joshua1990
Post Prodigy
6 years agoSumming 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:
| 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?
2 Replies
- AnonymousNot applicable
hello,
here is my small example, maybe it will help u : - AnonymousNot applicableWell, I'm afraid you've given us a bit less info than needed. We'd like to see your data model.