DAX Calculate with two Tables

[Anonymous]

Hi,

I got a question. Got two Tables, one DIM with the ID and one Fact with a ID and Value. Now I wan't to summarizes these values to the DIM Table.

Calculate(
Sum(Value),
DIM[ID]=Fact[ID])

 Thought I could handle it like that but that doesn't work. What must I do to solve my issue?

PS: I am using that in PowerPivot not PowerBI, but I guess it will work equally.

Thanks a lot

[Anonymous]

Awesome! Thanks a lot, works like a charm. 😀

[AlB · Accepted solution]

Hi @Anonymous 

If you have a relationship between the tables, this should be enough:

Calculate(Sum(Fact[Value]))

otherwise:

Calculate(Sum(Value), FILTER( ALL(Fact [ID]), Fact[ID]=DIM[ID]))

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers