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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

The Total line is essentially using DAX behind the scenses to aggregate the column. I would suggest that if it is not aggregating it the way you want to create a measure to do it the way you want.

mivar99's avatar
mivar99
Helper I
8 years ago

and the problem is that i already thought i did and it works in excel - i would have to try to make a different type of calculation in mdx where its already correct.

 

at this point no clue how but ill look more into it.

  • 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