Pareto not working when filters are applied

[Anonymous]

Hello, 

I've made a Pareto Chart, it worked well when i have no filters applied,

But if I apply any kind of filter it breaks,

I made the Pareto with RankX and TopN functions.

I think the problem is in the Ranking function,

Because i noticed that when 2 columns have the same value it doesn't accumulate as should

Image 1: Working Pareto

Image 2: Pareto Broke

If there's any other way to make the Pareto Chart or correct this error plz tell me.

[v-chuncz-msft]

@Anonymous ,

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/Running-Total-Through-Direct-Query/m-p/628353#M300215