Forum Discussion

Niels_83's avatar
Niels_83
Copper Contributor
Nov 17, 2025

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     ...
BI & Data Analysis
excel
Formulas and Functions
office 365
power bi
Niels_83's avatar
Niels_83
Copper Contributor
Nov 17, 2025

And what if there are multiple rows per EM in revenue table? Then it's not possible to make a connections between revenue table and AM table.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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

Resources