Forum Discussion

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 ...

Diamond Contributor

Nov 17, 2025

As variant you may add both tables to data model with relationship as

Add measure

Shared:=SUMX (
    Shares,
    Shares[share accountmanager]
        * RELATED ( Revenue[revenue] )
)

and build PivotTable from data model using above measure