DAX

[Bidya]

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)

[grazitti_sapna]

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.

[Anonymous · Accepted solution]

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]

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