Divide count of one column by the sum of another

[reh169]

I have a graph that is showing the total number/count of applciations over a time frame by application date for different marketing sources. I am acheiving this by just counting the number of application dates I have but I could count a different metric. I need to add a line for normalization and the calcuation for that  would be the count of applications by marketing source ( my x axis) / by the total number applications that occured.  Every measure or calculation that I do is giving me a 100% or a 1 so it is dividing by itself. How do I get around this?

[v-huizhn-msft]

Hi @reh169，

Plase try the solution @BILASolution posted, please feel free to ask if you have any other issue. And please mark the right reply if you have resolved your issue.

Thanks,
Angelia

[BILASolution · Accepted solution]

Hi @reh169

Measures:

Count Apps = COUNT(Table1[Application])

Total Apps = CALCULATE([Count Apps];ALL(Table1))

Division = DIVIDE([Count Apps];[Total Apps])

I hope this is what you're looking for

Regards

BILASolution

[Greg_Deckler]

Edit your denominator to be something like CALCULATE(COUNT([Column]),ALL(Table)). Essentially, you need to override the context of your denominator.