Forum Discussion

Bidya's avatar
Bidya
New Member
3 years ago
Solved

DAX

Hello Connection can you please help me with this power bi Dax
• Calculate revenue contribution of producer (if there is a producer X with 10,000 revenue out of total 100,000; when I select producer X result should show 10%; in the same way with revenue)

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Bidya ,

     

    Due to I don't know your data model, here I create a sample to have a test.

    Measure:

    Percentage = 
VAR _REVENUE =
    CALCULATE ( SUM ( 'Table'[Revenue] ) )
VAR _TOTAL =
    CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( _REVENUE, _TOTAL )

    Result:

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Bidya ,

     

    Due to I don't know your data model, here I create a sample to have a test.

    Measure:

    Percentage = 
VAR _REVENUE =
    CALCULATE ( SUM ( 'Table'[Revenue] ) )
VAR _TOTAL =
    CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( _REVENUE, _TOTAL )

    Result:

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    3 years ago

    For getting the revenue contribution.

    You can Create a new measure 

    REVENUE CONTRIBUTION- DIVIDE(SUM(TABLENAME[REVENUE]),CALCULATE(SUM(TABLENAME[REVENUE]),ALL(TABLENAME[PRODUCER]))) * 100

    ** make sure revenue and producer columns are in numeric and in text.

    Hope this will help.