Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 it in the right syntax.
Any help would be appreciated
Solved! Go to Solution.
Hi @Anonymous,
you can try
Hi @Anonymous ,
Please make sure you’ve enabled the % formatting for the column as below.
Here I’m suing DIVIDE function instead of “/” in case of infinity appears.
DIVIDE(numerator,denominator,0),
Column = DIVIDE([Diff Pop],Table1[Total population],0)
Hi @Anonymous,
you can try