Pareto Analysis for Top N account based on closed Date Filter selection

[Anonymous]

Hi All,

I have attached workbook in below URL

Pareto Analysis.pbix 

I have Two Filter Top N Account Selection Filter and Close Date Range Filter

Top N = 5

Close Date Range = 02/10/2015 to 03/13/2017

Based on sales value account was ranked

I want to do Pareto Analysis only for These 5 accounts (because Top N = 5), but in below screen it shows all Account 

To Remove Unwanted account i have used Is Top N account = 1

It shows Only Top 5 account But Cumulative % Line value was Wrong 

How can I do Pareto analysis only for Top N account based on closed Date Filter Value?

Please share your Knowledge (Source File: Pareto Analysis.pbix )

@v-lid-msft , @Zubair_Muhammad ,@v-juanli-msft

[v-chuncz-msft · Accepted solution]

@Anonymous 

Remove the visual level filter and use measures below instead.

Measure =
IF ( [Rank] <= SELECTEDVALUE ( 'Table 2'[Top N Filter] ), [$ Sales] )

Measure 2 =
IF ( [Rank] <= SELECTEDVALUE ( 'Table 2'[Top N Filter] ), [Cumulative %] )

[Anonymous]

Thank You v-chuncz-msft..... It Working.....