Forum Discussion
Solved
Calculating aggregates in DirectQuery mode
I'm new to PowerBI and am trying to do something that seems very simple but can't figure it out. I'm working with two SQL Server tables in DirectQuery mode. I'm trying to create a table visualiza...
Hi trevorloflin
Create relationship as below
Create a measure
Measure = SUM(foo[foovalue])+SUM(bar[barvalue])
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi trevorloflin
Create relationship as below
Create a measure
Measure = SUM(foo[foovalue])+SUM(bar[barvalue])
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! I was missing that a measure takes the context of the row it's in.