How to show MAX compared to Others using DAX

[cuongle]

Assume I have two tables:

1. DimSupplier

2. FactInvoice

Now I would like to show the marketshare of the biggest/max supplier (based on SUM of Spend) compared to others. (If no filter, supplier 1 is the biggest supplier with total spend 290)

How I can do in DAX? The biggest suppliers will be changed based on the filter from users.

[Greg_Deckler]

Create this measure:

Top Supplier = MAXX(SUMMARIZE(Suppliers,Suppliers[Supplier],"MySpend",SUM([Spend])),[MySpend])

Then create this measure:

Others = SUM(Suppliers[Spend]) - [Top Supplier]

Add these two measurs as values in your pie chart visualization.

[cuongle]

Thanks @Greg_Deckler, is there anyway that the name of biggest supplier can show up in the pie chart

[Greg_Deckler · Accepted solution]

I would use a Card visualization for that and put Supplier in there. Then, set a Top N filter (1) on that bad boy (Supplier) with a value of the Sum of Spend.

[cuongle]

Assume I have 2 two tables:

1. DimSupplier

2. FactInvoice

I tried to create New Table based on Group By with the code:

New Table = GROUPBY(FactInvoice, DimSupplier[Name], 
"TotalSpend", SUMX(CURRENTGROUP(), FactInvoice[Spend]))

The new table after creating:

But this new table is not dynamically filtered when user do filtering using slicer. So assume if only Supplier 1 and Supplier 2 are choosen. The table should only show data for Supplier 1 and Supplier 2.

Is this possible?

[Greg_Deckler]

You shouldn't need to create a table, just create a table visualization and put Supplier from DimSupplier into it as well as Spend with a SUM aggregation.

[cuongle]

I have posted my real problem in here:

https://community.powerbi.com/t5/Desktop/How-to-show-MAX-compared-to-Others/m-p/174881#M76420

My initial purpose is to create `table measure` in order to solve the above problem

[Greg_Deckler]

Got it, I just answered that one!!