Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to calculate the percentage value of one column compared to another one.
Here is a table that will illustrate my challenge.
When II try to achieve this in Power BI I obtain the following:
I've tried to understand if any filters could be affecting the result but I just cannot get my head around this.
All measures come from the same table.
Solved! Go to Solution.
@PowerBIUserUKB , Prefer using divide
like
Percent_SLA = divide([onlyMet] ,[onlyTotal])
Make it decimal with 2 decimal place and Mark as % column (in measure tool)
Thank you very much for the prompt reply; it solved my problem!
So the lack of decimal places rounded up all results to 1?
Is that all that I was missing?
@PowerBIUserUKB , Prefer using divide
like
Percent_SLA = divide([onlyMet] ,[onlyTotal])
Make it decimal with 2 decimal place and Mark as % column (in measure tool)
Thank you very much for the prompt reply; it solved my problem!
So the lack of decimal places rounded up all results to 1?
Is that all that I was missing?
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |