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 Amount. 

 

The current Matrix table in the sample pbix is current for the Values, but i want to replace the values with % based on Net Amount.

Sample File

https://www.dropbox.com/s/f6gpirjae9cf96a/TestData.pbix?dl=0 

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.

     

5 Replies

  • 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.