Forum Discussion
Percentage Calculation in Power BI
I have not use DAX for it, I am using %GT calculation in X Axis to get percentage, but t giving me incorrect one
What would you consider the correct result? How are you handling the "Under Assessment" option? I get very different results for "Yes"
- Service Order Status Response = Yes: This counts as a "Yes" for a program.
- Service Order Status Response = Planned: This only considers unique program numbers without other responses.
- Service Order Status Response = No: This also only considers unique program numbers without other responses.
- Service Order Status Response = Under Assesment: This also only considers unique program numbers without other responses.
The total percentage for all respnses should ne equal to 100%
You are only restating part of your original post and not providing any percentages.
How does that indicate your expected results? I thought the expected results would be a percentage for each status. But you don't show how they are derived.
What if a program has, for example, status responses of "No", "Planned" and "Under Assessment" for the different Service Order #'s?
You really need to be more specific. I cannot figure out, for example, how you derive 81% as the correct answer for "Yes".
How do calculate 81% "Yes"
What result would you expect for each of the Planned / Under Assessment / No categories.
The closest I can come, trying to use your written description, is:
