Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rodieade
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

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?

View solution in original post

8 REPLIES 8
lbendlin
Super User
Super User

Sounds great. What's your question?

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

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

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?Picture1.png

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?

thanks, that works.

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

Try something like this:

1.PNG2.PNG3.PNG4.PNG

CustomTotalSales = SUMX( CustomBrands, CustomBrands[TotalSales] )

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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