Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
hello,
here is my small example, maybe it will help u :
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |