Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |