Card to show Top N as a percentage of total

[veerub]

Hi All,

I need some assistance on getting the Top 3 as a percentage of total.

I have a dataset with three column Name, Category and Revenue.

I would like to have the following

1. a card which shows me the top 3 customer for clothing as a percentage of Total Clothing. From the sample, the expected result is 90%

2. a card which shows me the top 3 customer for clothing as a percentage of Total. From the sample, the expected result is 50.9%

Thanks

VB

[V-pazhen-msft]

@veerub

Add another expression to calculate by the sub category.

FILTER(ALLSELECTED('Table'),[Category]=MAX([Category])&& [clothing sub cate]=max([clothing sub cate]))

Paul

[V-pazhen-msft · Accepted solution]

@veerub 

Please refer to my example pbix, I put the 2 variables into 2 measures just to show clarify the calculation.

measure_ =

var top3 =SUMX(TOPN(3,FILTER(ALLSELECTED('Table'),[Category]=MAX([Category])),[Revenue],DESC),[Revenue])

var sum_ = SUMX(FILTER(ALLSELECTED('Table'),'Table'[Category]=MAX([Category])),[Revenue])

Return top3/sum_

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[veerub]

@V-pazhen-msft  , Thanks a lot for solution. I made some minor changes  as per below

top3A =

SUMX(

TOPN(3,

FILTER(ALLSELECTED('Table'),'Table'[Category]= "Clothing"),

[Revenue],

DESC),

But I still have a challenge. I realised that clothing had a sub category another column (type). How do i summarise clothing by type, so that the Top 3 clothing give me the top 3 clothing by type?

'Table'[Revenue])