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
SerenatMacar's avatar
SerenatMacar
New Member
4 years ago
Hi! Try to create a measure like this and use FORMAT to get the percentage value.

BluePercentage =
var __bluePerc = DIVIDE([BlueNumber], [BlueNumber]+[GreenNumber])
return "The"&FORMAT(__bluePerc, "Percent") &" of the values are blue."