Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Tricky - percentage Calculation

Hi Experts   How would you calculate the Percentage values Based on the Net Amount, I.e. I want the Percentage of Allocation in Month / Net Amount and the individual months 1- 6 divided by the Net ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    Redo your measure to

     

    Allocation Month =
DIVIDE (
    SUM ( SampleData[Net Amount] ),
    CALCULATE (
        SUM ( SampleData[Net Amount] ),
        FILTER (
            ALL ( SampleData[YearMonth], SampleData[New Month] ),
            SampleData[YearMonth] = SELECTEDVALUE ( SampleData[YearMonth] )
        )
    )
)

     

    Only question I have is regarding the allocation in Month do you also need to have it divided by the total?

    In this case you need to redo the way your table is presented.

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

You just need to make the following measure:

Percentage of Allocation in Month = DIVIDE(SUM(SampleData[Allocation in Month]) , SUM(SampleData[Net Amount]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi MFelix - firstly apologies if i did not explain the question. But the image below is the end result i am looking for...

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      Hi Anonymous ,

       

      Redo your measure to

       

      Allocation Month =
DIVIDE (
    SUM ( SampleData[Net Amount] ),
    CALCULATE (
        SUM ( SampleData[Net Amount] ),
        FILTER (
            ALL ( SampleData[YearMonth], SampleData[New Month] ),
            SampleData[YearMonth] = SELECTEDVALUE ( SampleData[YearMonth] )
        )
    )
)

       

      Only question I have is regarding the allocation in Month do you also need to have it divided by the total?

      In this case you need to redo the way your table is presented.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi MFelix....re;In this case you need to redo the way your table is presented. how?