Forum Discussion
adding / sum lookupvalue
Hello Everyone! Quick question is there a way to add up values that are coming from a measure that uses lookupvalue? Here's the measure: lookupvalue = LOOKUPVALUE(Report[SUM_SERVICE_MONTHL...
So typically, you use VAR to create a temp table using SUMMARIZE or ADDCOLUMNS and then feed that into a SUMX or something along those lines. See the basic technique here:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Thank you :)
I have already tried this one, but ones again like this:
sumx = SUMX(SUMMARIZE(Report; Report[LINK_CODE];Report[Custom_date]; "look"; [lookupvalue]);[look])
sumx = SUMX(ADDCOLUMNS(Report; "look"; [lookupvalue]; "link"; Report[LINK_CODE]; "date"; Report[Custom_date]);[look])and also when I tied to make a separate table I get this error:
A table of multiple values was supplied where a single value was expected
