Need to calculate percentage of total and show using the sum of two columns against a third column.

[E12345]

Hi! 

I need a proper DAX function to display the percentage ratio of column C over (O + BA).
The data is already grouped (contained within a matrix chart), with each line representing a grouping. 

I am new to BI, please help me figure it out, thanks a million! 

The screenshot below shows the right data as an example - I need a DAX functuion that would represent Ratio C/(O+BA)% column.

[aj1973 · Accepted solution]

Hi @E12345 

DAX = 

       VAR _C = SUM (TABLE[column C])

       VAR _O_BA = SUM (TABLE[O]) + SUM (TABLE[BA])
       VAR _Result = DIVIDE( _C , _O_BA , 0)

      RETURN

_RESULT

[E12345]

Hi Amine,

Thank you for your prompt reply, the function worked! I did not expect the answer to come from a simple SUM! Many many thanks! 😉

[aj1973]

Can you share a sample of your Model, please? it is hard for me to speculate.

[E12345]

Amine, the function worked! Thanks! I got it wrong at first but then I realized my mistake. All is well.