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?

      • MFelix's avatar
        MFelix
        Super User
        5 years ago

        Do you want to divide the allocation total also?

         

        If yes you need to change your measure and also add a new disconnected table so that every thing is presented correctly and not duplicate.