Calculate absolute profitability

[brunoguedes]

Hello,

I'm new to power bi and my English sucks. I need a lot of help. I need to calculate the absolute profitability of a column with several values that are modified by the date. According to the image below:

Can someone help me?

help!!!

[Sean · Accepted solution]

@brunoguedesOkay so you want the percent calculated ALWAYS from the first date selected in the slicer!

Like in this picture... => % of First Selected Date's Total

So to achieve this create these 4 MEASURES

Total Value = SUM ( Table[Value] )

First Date = CALCULATE ( FIRSTNONBLANK ( Table[Date], 1 ), ALLSELECTED ( Table ) )

First Value =
CALCULATE (
    [Total Value],
    FILTER ( ALLSELECTED ( Table ), Table[Date] = [First Date] )
)

% MEASURE =
IF (
    HASONEVALUE ( Table[Date] ),
    DIVIDE ( [Total Value] - [First Value], [First Value], 0 )
)

Hope this helps.

Good Luck!

[Sean]

@brunoguedesYou can try couple things - both should give you the same answer!

1) Create a MEASURE with a formula that should look something like this...

% of Grand Total =
DIVIDE (
    SUM ( TableName[Column Name] ),
    CALCULATE ( SUM ( TableName[Column Name] ), ALLSELECTED ( TableName ) ),
    0
)

OR

2) Click to the right of the column name (the one with the numbers) and use the Quick Calculation option

Hope this helps.

Good Luck!

[brunoguedes]

Thank you for your attention,

Did not work, the result should be like the one highlighted in the blue picture. Its result was like the columns highlighted in red. I need the% value to always depart from 0 in the first row - after filtering the date.

[Sean · Accepted solution]

@brunoguedesOkay so you want the percent calculated ALWAYS from the first date selected in the slicer!

Like in this picture... => % of First Selected Date's Total

So to achieve this create these 4 MEASURES

Total Value = SUM ( Table[Value] )

First Date = CALCULATE ( FIRSTNONBLANK ( Table[Date], 1 ), ALLSELECTED ( Table ) )

First Value =
CALCULATE (
    [Total Value],
    FILTER ( ALLSELECTED ( Table ), Table[Date] = [First Date] )
)

% MEASURE =
IF (
    HASONEVALUE ( Table[Date] ),
    DIVIDE ( [Total Value] - [First Value], [First Value], 0 )
)

Hope this helps.

Good Luck!

[brunoguedes]

brother,

I need to calculate interest accrued in the period, but now it will not start from the '' zero ''. Can you help me?

[brunoguedes · Accepted solution]

Very good! Very good!

Thank you very much!!!