Forum Discussion
Aggregation over LOOKUPVALUES
Hi Greg, thanks for the link. I guess my databases was big so I thought describing a simplified version of it would be easier to understand. After another hour of googling I found I think the better way that I was looking for which is (column-by-column) in the 'Table' visualisation:
GROUP,
Measure1 = SUMX( A, RELATED(B[FACTOR]) ),
Measure2 = SUMX( A, A[PRICE] * RELATED(B[FACTOR]))
That's lots of words. Sample data with an example of what you want as output is much easier to understand. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg, thanks for the link. I guess my databases was big so I thought describing a simplified version of it would be easier to understand. After another hour of googling I found I think the better way that I was looking for which is (column-by-column) in the 'Table' visualisation:
GROUP,
Measure1 = SUMX( A, RELATED(B[FACTOR]) ),
Measure2 = SUMX( A, A[PRICE] * RELATED(B[FACTOR]))