cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Contribution of Top Performers in DAX

Dear Experts,

I have a table like below:

 Zone Brand Customer Bill Amount NORTH BRAND-002 [1000000216] 100 EAST BRAND-002 [1000000229] 91 EAST BRAND-002 [1000000231] 44 NORTH BRAND-002 [1000000280] 40 EAST BRAND-001 [1000000220] 39 NORTH BRAND-002 [1000000257] 33 NORTH BRAND-002 [1000000220] 29 EAST BRAND-001 [1000000216] 22 EAST BRAND-002 [1000000477] 22 NORTH BRAND-001 [1000000414] 19 EAST BRAND-001 [1000000229] 12 EAST BRAND-002 [1000000230] 10 NORTH BRAND-001 [1000000400] 10 EAST BRAND-002 [1000000230] 8 NORTH BRAND-002 [1000000400] 8 EAST BRAND-001 [1000000230] 6 NORTH BRAND-001 [1000000248] 5 NORTH BRAND-001 [1000000231] 4 EAST BRAND-001 [1000000224] 3 EAST BRAND-001 [1000000231] 2 NORTH BRAND-001 [1000000406] 2 NORTH BRAND-001 [1000000229] 0.5

I need to calculate a measure - Total Billed Amount for Top 3 Customers and want to plot the measure for each Zone.

Brand can be selected from a slicer (Multiple selection).

I am expecting the following table when all Brands are selected:

 Zone Billed Amount (Top 3 Customers) EAST 188 NORTH 173

I am expecting the following table when only BRAND-001 is selected in slicer:

 Zone Billed Amount (Top 3 Customers) EAST 73 NORTH 34

If anyone can help me with the DAX to calculate the measure it would be of great help.

Thanks.

1 ACCEPTED SOLUTION
Super User

hi @GreenP

try to plot the zone column and a measure like this:

``````Top3Amt =
CALCULATE(
SUM(TableName[Bill Amount]),
TOPN(
3,
ALL(TableName[Customer]),
CALCULATE(SUM(TableName[Bill Amount]))
)
)``````

verified and worked like this:

Super User

hi @GreenP

try to plot the zone column and a measure like this:

``````Top3Amt =
CALCULATE(
SUM(TableName[Bill Amount]),
TOPN(
3,
ALL(TableName[Customer]),
CALCULATE(SUM(TableName[Bill Amount]))
)
)``````

verified and worked like this:

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors