Forum Discussion

SachinC's avatar
SachinC
Helper V
9 years ago

Percentage DAX Formula

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...
Need Help
SachinC's avatar
SachinC
Helper V
9 years ago

See attached. I have manually computed the % value in the pivot, I can't seem to do this in PowerBI. 

All the columns are text, I am doing counts to get numeric values from them.  Thanks.

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

SachinC

 

Hi, please try with these measures:

 

CountAudiences = COUNTA(Table1[Audience])

CountClicks = CALCULATE(COUNTA(Table1[Clicks]),FILTER(Table1,Table1[Clicks]<>BLANK()))

% = DIVIDE([CountClicks],[CountAudiences])