cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Apply specific percentage to values

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

1 ACCEPTED SOLUTION
Community Champion

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?

8 REPLIES 8
Super User

Frequent Visitor

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

Community Champion
Something like
Measure = 0.45 * CALCULATE ( SUM ( total investment ), ALL ( ColumnNameThatYouWillSliceBy ) )
Frequent Visitor

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?

Community Champion

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?

Frequent Visitor

thanks, that works.

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

Community Champion

Try something like this:

``CustomTotalSales = SUMX( CustomBrands, CustomBrands[TotalSales] )``
Super User

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors