add % of total column to filtered matrix

[bvdm1980]

Hi 

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!

[FreemanZ · Accepted solution]

hi  @bvdm1980

try like:

DIVIDE(

  SUM(fact_orderlines[order amount]),

  CALCULATE(

      SUM(Fact_orderlines[order amount]),

      ALLSELECTED(Fact_orderlines[Supplier Name])

    )

)

[bvdm1980]

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]))