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
tobkres
Helper II
Helper II

Calculate a percentage, based on separate rows

Hello community.

 

I need some help with creating a percentage based on buttom of a table and the top.

tobkres_0-1655794376568.png

I need it to take the 86.160,69 (Dækningsbidrag) and divide it by 95.038,00 (Omsætning) and shown as a percentage beside the number 86.160,69. 

 

Any help would be appreciated.

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @tobkres 
Please try this code. Please adjust the spilling of the words.

Bel∅b Measure =
VAR NormalValue =
    SUM ( TableName[Bel∅b] )
VAR OmstaetningValue =
    CALCULATE (
        SUM ( TableName[Bel∅b] ),
        TableName[N∅glital DKK] = "OmstaetningValue"
    )
RETURN
    IF (
        HASONEVALUE ( TableName[N∅glital DKK] ),
        NormalValue,
        NormalValue & " ("
            & FORMAT ( DIVIDE ( NormalValue, OmstaetningValue ), "Percent" ) & ")"
    )

View solution in original post

5 REPLIES 5
tobkres
Helper II
Helper II

Thank you for helping me out. I have tried, but i get the following error.

Column 'Inversbeloeb' in table 'MeasureTable' cannot be found or may not be used in this expression.

 

This is the code: 

DG percentage = 
VAR NormalValue =
    SUM ( MeasureTable[Inversbeloeb] )
VAR RevenueValue =
    CALCULATE(
        SUM ( MeasureTable[Inversbeloeb] ),
        Sortorder[KontoOverskrift] = "RevenueValue"
    )
RETURN
    IF (
        HASONEVALUE ( Sortorder[KontoOverskrift] ),
        NormalValue,
        NormalValue & " ("
            & FORMAT ( DIVIDE ( NormalValue, RevenueValue ), "Percent" ) & ")" 

 

These are the fields.

tobkres_0-1655800294179.png

 

Have i missed something?

@tobkres 
Please try

DG percentage =
VAR NormalValue = [Inversbeloeb]
VAR RevenueValue =
    CALCULATE ( [Inversbeloeb], Sortorder[KontoOverskrift] = "RevenueValue" )
RETURN
    IF (
        HASONEVALUE ( Sortorder[KontoOverskrift] ),
        NormalValue,
        NormalValue & " ("
            & FORMAT ( DIVIDE ( NormalValue, RevenueValue ), "Percent" ) & ")"
    )

Seems like it just returns the same numbers.

tobkres_1-1655804228635.png

 

 

 

@tobkres 
Please make sure you are using the correct spilling. Copy the name from inside the column. If you want we can connect via zoom. Will take only 10min to sort it out.

tamerj1
Super User
Super User

Hi @tobkres 
Please try this code. Please adjust the spilling of the words.

Bel∅b Measure =
VAR NormalValue =
    SUM ( TableName[Bel∅b] )
VAR OmstaetningValue =
    CALCULATE (
        SUM ( TableName[Bel∅b] ),
        TableName[N∅glital DKK] = "OmstaetningValue"
    )
RETURN
    IF (
        HASONEVALUE ( TableName[N∅glital DKK] ),
        NormalValue,
        NormalValue & " ("
            & FORMAT ( DIVIDE ( NormalValue, OmstaetningValue ), "Percent" ) & ")"
    )

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.