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

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.