Forum Discussion
Percentage total in table using direct query to cube wrong
I have a simple percentage calculation in cube that only shows correct total number in powerbi when i show elements without data on the attribute i dragged in
as you see the 981 mio doesnt change but the percentage does - makes no sense and probelm doesnt exist in excel
7 Replies
Take a look at this article:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
tx for the input but i dont think its an issue like this.
First of all i dont use dax for calculations - i connect to a live multimension cube (maybe powerbi uses dax behind the scenes)
I made my calculation inside the cube (since i didnt have any option to do local calculations on live cube connection)
and then last but not least. Excel shows it correctly out of the box ?
and the number shouldnt change when u say yes to show empty members ? if they are empty they shouldnt affect calculation ? Excel filters out the empty ones automatically and still shows correct percetnage calculation ?
