New Measure by Dividing two existing columns

[cshowe80]

I'm hoping I can get a bit of help. I've got two columns in my data tables and I'm trying to divide one by the other to give me a percentile output. 

It's a simple Click Through Rate (CTR) formula which is Clicks/Impressions. Ideally I would like to see a card visualization which shows just the CTR as a percentile output. 

DATA[CLICKS] is the first cloumn and DATA[IMPRESSIONS] is the other. 

Any help would be greatly apprecaited. 

[KGrice · Accepted solution]

Hi @cshowe80. I'd start with creating three new measures. Names are up to you, but something like:

Sum of Clicks = SUM(DATA[CLICKS])

Sum of Impressions = SUM(DATA[IMPRESSIONS])

CTR = [Sum of Clicks] / [Sum of Impressions]

After you create the last measure, make sure you have it selected and you can also format it as a percent. If there's a possibility of a divide by 0 error, you can handle it instead with the DIVIDE function. You can provide a third parameter to specify how to handle an error, or leave it blank and it will return BLANK by default.

CTR = DIVIDE([Sum of Clicks], [Sum of Impressions])

If you need something more specific based on filter criteria or anything else, just let us know!

[Anonymous]

This solution worked out excellent, thank you @KGrice!

I had a similar situation where I needed to divide two existing columns (Direct Margin YearTotal / Revenue YearTotal) to produce a Direct Margin(%) measure to be applied to a Card visualization.

In my case, I broke it down like this:

Measure 1: Sum of DM(USD) = SUM('Data'[Direct Margin YearTotal])

Measure 2: Sum of Rev(USD) = SUM('Data'[Revenue YearTotal])

Measure 3: DM(%) = DIVIDE([Sum of DM(USD)], [Sum of Rev(USD)])

Measure 3 was applied to a Card visualization in the correct amount!

[cshowe80]

Thanks for the reply. I took your advice and it worked perfectly. I can't thank you enough. 

-C