topic Apply specific percentage to values in DAX Commands and Tips

Apply specific percentage to values

rodieade — Tue, 07 Jul 2020 14:13:08 GMT

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

Re: Apply specific percentage to values

lbendlin — Tue, 07 Jul 2020 14:08:19 GMT

Sounds great. What's your question?

Re: Apply specific percentage to values

rodieade — Tue, 07 Jul 2020 14:13:53 GMT

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

Re: Apply specific percentage to values

AntrikshSharma — Tue, 07 Jul 2020 14:21:39 GMT

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

Re: Apply specific percentage to values

rodieade — Tue, 07 Jul 2020 14:54:46 GMT

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?

Re: Apply specific percentage to values

AntrikshSharma — Tue, 07 Jul 2020 15:09:09 GMT

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?

Re: Apply specific percentage to values

rodieade — Tue, 07 Jul 2020 15:34:45 GMT

thanks, that works.

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

Re: Apply specific percentage to values

lbendlin — Tue, 07 Jul 2020 15:52:51 GMT

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.

Re: Apply specific percentage to values

AntrikshSharma — Wed, 08 Jul 2020 09:01:43 GMT

Try something like this:

CustomTotalSales = SUMX( CustomBrands, CustomBrands[TotalSales] )