Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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
Edit your denominator to be something like CALCULATE(COUNT([Column]),ALL(Table)). Essentially, you need to override the context of your denominator.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |