Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating Calculate Percentage column

Hi,   I want to be able to create a column which calcluates the percentage using 2 exisiting columns: Brand Opt-in / Total Entries * 100.  I have tried several DAX formulas but have failed to shape...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    you can try 

    Percentage = CALCULATE(SUM(Table[Brand Opt-in]))/CALCULATE(SUM(Table1[Total Entries]))*100.
    You create a calculated measure instead of column.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

you can try 

Percentage = CALCULATE(SUM(Table[Brand Opt-in]))/CALCULATE(SUM(Table1[Total Entries]))*100.
You create a calculated measure instead of column.