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:
Then I have a Fact Sheet with the Value per Article per Day
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?
hello, here is my small example, maybe it will help u :
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!