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 ,

 

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.