Forum Discussion

bhavick360's avatar
bhavick360
New Member
1 year ago
Solved

DAX Calculation

What is my dax calculation to get percentage on the table below first line should be 26.4%?

3541/13388

 

Need Help
  • Gabry's avatar
    Gabry
    1 year ago

    Hello,

    Percentage = DIVIDE(SUM([Handset]), SUM([Insurance]), 0)


    then format as percentage

2 Replies

  • Gabry's avatar
    Gabry
    Super User
    1 year ago

    Hello,

    Percentage = DIVIDE(SUM([Handset]), SUM([Insurance]), 0)


    then format as percentage

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    Hi bhavick360 , please use the below measure

     

    Percentage = DIVIDE(SUM(Table[Insurance],SUM(Table[Handset]),0)

     

    Format the above measure as %

    Thanks,

    Jai