Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
68 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |