Forum Discussion

mivar99's avatar
mivar99
Helper I
8 years ago

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 d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI mivar99,

 

I think this issue may related to different filter logic/calculation on matrix and pivot table side. 

 

As smoupre said, sometimes you need to add filters and additional calculation formula in your measure to make sure the formulas get correct result on 'total' row.

 

For any detail about internal formula calculation process, you can try to contact to power bi dev team for further support.

 

Regards.

Xiaoxin Sheng

mivar99's avatar
mivar99
Helper I
8 years ago

hI !

 

As i see it its a DAX to MDX powerbi problem

 

Its a super simple straight forward percetntage calculation that works ok in excel that uses "normal" mdx to query the cube

 

I am sure other mdx front end tools would show the same

 

But i will see if the mdx formula can be changed to something that also works in powerbi

 

[Measures].[Disbursement (DKK)]/([Budget].[Indicatorstatus].[All],[Measures].[Disbursement (DKK)])

 

/m