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.

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.