cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshua1990
Post Prodigy
Post Prodigy

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 2
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.
Anonymous
Not applicable

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

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!