Calculated Columns Question

[bobbybamber]

Hi guys,

Been using Power BI for about two days, so forgive a possibly obvious quesiton.

I'm trying to make a calculated column work, yet despite it being very simple I can't work out why it isn't coming out with what I want.

(Few notes - [C-TL] = "Leads" in the first column, [C-QU] = Qualified in the second column).

"LQ Rate" is a calculated column, the idea to divide the number of qualified leads by the total number of leads to generated a qualified lead %.

In screenshot one, I've simply made LQ Rate = "TL" (total leads), which shows the number of leads... just to prove it knows what it's looking at.

In screenshot two, I've done the same just with qualified leads. Again, just to prove a point

However, whenever I try and divide them together, nothing seems to happen.

Any ideas?

[vcastello · Accepted solution]

Hi @bobbybamber

Try the following.

1.- Create three Measures like this

Measure1 = SUM('CRM Data'[C-TL])

Measure2 = SUM('CRM Data'[C-QU])

LQ Rate = DIVIDE([Measure2],[Measure1])

2.- Put the LQRate Measure in the visual

Does it work?

Vicente

[bobbybamber]

@vcastello- perfect. Thank you!