Issue with percentage metric over sorted column

[Anonymous]

Good morning!

I would like your help with the next issue.

I'm working on Power BI consuming data from a SSAS Tabular Model. In this model, i have defined a metric like this:

somePercentage := divide([someCountMetric];calculate([someCountMetric];allselected(anyTable[anyColumn])))

At first, anyColumn wasn't sorted and the metric worked just fine. The issue began when i applied a sort over anyColumn by anotherColumn in the same table. At this point, when consumig the model from Excel, it worked fine and showed the exact calculated values, but in Power BI all the values where shown as 100%, so i had to remove the sorting from the column for it to work fine

It is not the first time that i see this behavior and i would like any light about this.

Thanks for your help.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Sort-By-Column-changes-the-Measure-results/m-p/91258#M38515

[Anonymous]

¡Thanks a lot! Right to the point.