Forum Discussion

KjRog's avatar
KjRog
New Member
6 years ago
Solved

Percentage in Matrix

See picture.

By using Matrix Power BI sums up the percentage in total amount.

I really want to calculate it instead. 

In example : 2435/ 22911 = 10,6% (not 180,9%.)

 

 

Any good tips to do this

Need Help
  • dedelman_clng's avatar
    dedelman_clng
    6 years ago

    Hi KjRog  - 

     

    Use this measure:

     

    Bidrag % =
CALCULATE ( DIVIDE ( SUM ( Datum[Bidrag] ), SUM ( Datum[Prod] ), 0 ) )

     

     

    Hope this helps

    David

     

1 Reply

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi KjRog  - 

     

    Use this measure:

     

    Bidrag % =
CALCULATE ( DIVIDE ( SUM ( Datum[Bidrag] ), SUM ( Datum[Prod] ), 0 ) )

     

     

    Hope this helps

    David