Get Current Year Product total sale which are in Last year top 10

[rajendermakhija]

Dear,
We want to get % of total sale of current year products which are in top 10 in last year vs. total sale in current year across all product.

Please refer the attachment

where we need last row which we can show as Card tool instead of showing in same column.

Regards,

Rajender

[Melissa]

Hi @rajendermakhija,

See this thread for a technique that will help you with this.

Top N Filter when drilling through hierarchy

Hi @Eric, Thanks for providing a sample file Can you see if this works for you. Top5 By Country/City = VAR TopFiltered = CALCULATETABLE( GENERATE( VALUES( Location[County] ), TOPN( 5, CALCULATETABLE( VALUES ( Location[City] ) ), [Total Profits] ) ), ALLSELECTED() ) RETURN IF( NOT( ISINSCOPE( Location[City] )), [Total Profits], CALCULATE( [Total Profits], KEEPF…

However should you require further assistance, provide a PBIX and mock up of the desired result so members can better assist you.

[EnterpriseDNA]

Hi @rajendermakhija, we’ve noticed that no response has been received from you since the 27th of November. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

[EnterpriseDNA]

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!