Forum Discussion
Niels_83
Nov 17, 2025Copper Contributor
power query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 ...
- Nov 17, 2025
You may use measure like
Shared := VAR TotalRevenue = SUMMARIZE ( Revenue, Revenue[category], "Revenue", SUM ( Revenue[revenue] ) ) VAR AddShares = ADDCOLUMNS ( CROSSJOIN ( TotalRevenue, Shares ), "ToTake", Revenue[category] = Shares[employee] ) VAR Filtered = FILTER ( AddShares, [ToTake] ) VAR KeepColumns = SELECTCOLUMNS ( Filtered, "Employee", [employee], "Manager", [accountmanager], "Revenue", [revenue], "Share, %", [share accountmanager] ) VAR Result = ADDCOLUMNS ( KeepColumns, "Shared", [Revenue] * [Share, %] ) RETURN SUMX ( Result, [Shared] )For Power Query only no changes are required
Harun24HR
Nov 17, 2025Bronze Contributor
Here is a formula approach if table are loaded to sheet.
=PIVOTBY(D2:D12,E2:E12,XLOOKUP(D2:D12,A2:A9,B2:B9)*F2:F12,SUM,0,0)