Forum Discussion

Niels_83's avatar
Niels_83
Copper Contributor
Nov 17, 2025
Solved

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     ...
  • SergeiBaklan's avatar
    SergeiBaklan
    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