Forum Discussion
Anonymous
5 years agoNot applicable
Column Comparison Percent of progress
I'm new to Power BI and I want to show the total percent of miles complete against the forecasted miles. I want my stacked bar chart to reflect that 84.9% of forecasted miles have been completed. How...
Anonymous
5 years agoNot applicable
Hi Anonymous ,
Can you provide your expectations what the bar graph looks like?
From the data you give to test, the following measurement can get 84.9%
Measure = DIVIDE(SUM('Table'[Miles Complete]),SUM('Table'[Forecast Miles]))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous5 years agoNot applicable
It is responding by saying the Expression Error: The name 'Divide' wasn't recognized, make sure its spelled correctly, but looks like its spelled correctly.