Sum of Top 10

[Anonymous]

Hi 

I want to put the sum of the top 10 companies in a card. 

CLACC HOURS, CLACC VALUE, ADMIN HOURS, ADMIN VALUE are Measures. 

Please help

Company Name	CLACC Hours	CLACC Value	ADMIN Hours	ADMIN Value	Total Hours	Total Value
Company A	84.33333333	23965.74			84.33333	23965.74
Company B			33.5	12496.2	33.5	12496.2
Company C	204.3333333	8171.58	6.75	2499.91	211.0833	10671.49
Company D	4.916666667	585.27	28	8216.1	32.91667	8801.37
Company E			22.45833333	8279.98	22.45833	8279.98
Company F			20.91666667	7802.37	20.91667	7802.37
Company G			21	7790.76	21	7790.76
Company H	25.83333333	4436.03	5.166666667	1927.29	31	6363.32
Company I	21.66666667	6139.96			21.66667	6139.96
Company J	41.5	5661.13			41.5	5661.13
Company K			14.58333333	5439.88	14.58333	5439.88
Company L			14.16666667	5284.47	14.16667	5284.47
Company M	40.75	5250.31			40.75	5250.31

[Jihwan_Kim · Accepted solution]

Hi, 

I assume the number has to show top 10 companies by total value.

Please check the below picture and the attached pbix file if it shows the desired outcome.

It is for creating a measure.

Top 10 company by value: =
CALCULATE (
    [Total Value measure:],
    KEEPFILTERS (
        TOPN ( 10, ALL ( Data[Company Name] ), [Total Value measure:], DESC )
    )
)

[Anonymous]

@Jihwan_Kim Thank you so much. It is working now