Forum Discussion
Conditional Sum calcution between two tables
3 Replies
dofrancis3 Hi! Create a measure like:
D1_Percentage =
VAR Z_Value = LOOKUPVALUE( Table1[Z], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[D1a] + Table2[D1b], Z_Value, 0)D9_Percentage =
VAR Z_Value = LOOKUPVALUE( Table1[Z], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[D9], Z_Value, 0)MC1_Percentage =
VAR U_Value = LOOKUPVALUE( Table1[U], Table1[Country], SELECTEDVALUE(Table2[Country]) )
RETURN DIVIDE( Table2[MC1], U_Value, 0)-- Repeat for other percentages using the same pattern
BBF
Hi dofrancis3 ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
