Forum Discussion

sudhakar111's avatar
sudhakar111
Icon for Helper IV rankHelper IV
9 years ago
Solved

Problem with Cumulative percentage

Hi All,   I am facing an issue with the cumulative percentage totals. The table being used is Matrix preview.     I have 3 levels in my report like a hierarchy. The measure fields used are...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi sudhakar111,

    But i need to show it as 2016-Apr,2016-May and so on in that order.

     

    It is only showing in alphabetical order like 2016-Apr,2016-Aug and so on.

    You should be able to follow steps below to get this work. :smileyhappy:

     

    1. Select "Year Month" column.

    2. Click Sort by Column under Modeling tab.

    3. Select "Month Year"

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi sudhakar111,

 

After looking into your shared pbix file, I find that you're using a calculate column to calculate the percentage. So the percentage will be added up at the 1st and 2nd levels.

 

In this scenario, you should create a measure instead to calculate the percentage, then it should work as expected in the Matrix preview.

 

Difference % Measure = 
DIVIDE (
    SUM ( Merge1[Budget] ) - SUM ( Merge1[Actual] ),
    SUM ( Merge1[Budget] )
)

 

 

 

Regards