Measure to get total of all text values and using Top N

[mehlenbae2]

Hi,

I am have two pie charts that I want to show Top Businesses and Top Locations. There are so many locations and businesses I need to knock what is shown in the visualization to Top 5, which I can do by using the Top N PowerBI feature. However, the totals change when I use the Top N feature.

I need to create a measure that gives me my Top 5 Locations using the Top N feature but still is calculating the total of the entire column.

How can I do this?

[jdbuchanan71 · Accepted solution]

You can use a measure like this to force the total row to calculate the full amount.

Amount Full Total =
IF (
    NOT HASONEVALUE ( Companies[Company Name] ) && NOT HASONEVALUE ( Companies[Location] ),
    CALCULATE ( [Sales Amount], ALL ( Companies ) ),
    [Sales Amount]
)