Forum Discussion

brunoguedes's avatar
brunoguedes
Frequent Visitor
9 years ago
Solved

Calculate absolute profitability

 

 

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!!!

 

Need Help
  • Sean's avatar
    Sean
    9 years ago

    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! :smileyhappy:

5 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    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! :smileyhappy:

     

    • brunoguedes's avatar
      brunoguedes
      Frequent Visitor
      9 years ago

       

      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's avatar
        Sean
        Community Champion
        9 years ago

        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! :smileyhappy: