Apply specific percentage to values

[rodieade]

Hello,

I have a table with a specific value (=total investment) on which I'd like to apply specific percentages (=fixed): 45% of the total investment, and then 10% of the total investment to use then those calculated values for other calculation. WHat formula should I use to create those 45% / 10% calculation?

thanks

[lbendlin]

Sounds great. What's your question?

[rodieade]

Sorry went to quick on the message. I'd like to undertsand what formula to use to create the 45% / 10% calculation on a specific field. thanks

[AntrikshSharma]

Something like
Measure = 0.45 * CALCULATE ( SUM ( total investment ), ALL ( ColumnNameThatYouWillSliceBy ) )

[rodieade]

Thanks, I was so able to apply specific percentage to the values.

Now I am a bit stuck at the next step of my calculations - posting a picture to make it more clear (ultimately looking to calculate last line = full category A). I need to apply the percentages of each $ field per category ; and then do some sums. Can I include the filtering of category in the formulas?

[AntrikshSharma · Accepted solution]

Maybe something like:

Full Category A =
CALCULATE (
    SUM ( Table[TotalInvestment] ),
    KEEPFILTERS ( Category[Column] = "A" )
)
    + 0.45
        * CALCULATE (
            SUM ( Table[TotalInvestment] ),
            KEEPFILTERS ( Category[Column] = "D" )
        )

How will you add that the last 2 rows of the visuals?

[rodieade]

thanks, that works.

indeed I dont know how to build the rows - is it possible?

[AntrikshSharma]

Try something like this:

CustomTotalSales = SUMX( CustomBrands, CustomBrands[TotalSales] )

[lbendlin]

If you only ever have categories A to D then you can create a measure for each (plus the two measures for the last two lines).  

The moment you have a dynamic list of categories you're basically out of luck.