Percentage DAX Formula

[SachinC]

Hi,

I want to create a percentage figure, i.e. x%, from two text fields.

It's basically calculating click through rate as a %. I've got a count of my audience for a mailshot in a column, a count of clicks in another column but I need to compute click through % line by line.  Help!? 

Regards,

S

[v-huizhn-msft]

Hi @SachinC,

You can upload your anonymise Excel to onedrive. We can download it.

Best Regards,
Angelia

[SachinC]

ok, it's now mysteriously working. No idea what happened, but its all looking well. thanks for your help.

[v-huizhn-msft]

Hi @SachinC，

You have resolve your issue? If it does, please mark the corresponding reply as answer, which will help more people.

Thanks,
Angelia

[SachinC]

I think I understand where you are coming from but I am lost.  Can you explain again please.  you are right, the values have blanks. Thanks.

[SachinC]

Hi thanks for that. However, my values for Column A and Column B is text.  I am counting Column A and ColumnB but I want to do an inline percentage. See example below.  33 and 31 are counts of Text fields, I want to