Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
¡Thanks a lot! Right to the point.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |