topic add % of total column to filtered matrix in DAX Commands and Tips

add % of total column to filtered matrix

bvdm1980 — Wed, 08 Mar 2023 14:30:37 GMT

I have a matrix table, with columns:

Supplier Name

Order Amount

I filtered this table to get the top 10 of suppliers.

But how do i add a column in that matrix showing the % of the total order amount for all suppliers?

I tried this:

DIVIDE(
SUM(fact_orderlines[order amount]),
CALCULATE(
SUM(Fact_orderlines[order amount]),
ALLSELECTED(Fact_orderlines[order amount])))

but that aint working. I searched on internet but didnt find solution yet or maybe i found it but am using the dax wrong?

thanks for the help!

Re: add % of total column to filtered matrix

FreemanZ — Wed, 08 Mar 2023 14:48:17 GMT

hi bvdm1980

try like:

DIVIDE(

SUM(fact_orderlines[order amount]),

CALCULATE(

SUM(Fact_orderlines[order amount]),

ALLSELECTED(Fact_orderlines[Supplier Name])

)

Re: add % of total column to filtered matrix

bvdm1980 — Wed, 12 Apr 2023 07:40:53 GMT

Thanks for the help (sorry for the late reply :)). Only seeing it just now.

I found another solution that works like a charm as well:

DIVIDE(

SUMX(

TOPN(10,Fact_orderlines, SUM(Fact_orderlines[Amount])),

Fact_orderlines[Amount]),

SUMX(ALLSELECTED(Fact_orderlines), Fact_orderlines[Amount]))