Forum Discussion
Divide in Power BI
Hi FarhanAhmed ,
For the data you share, you may create two measures instead of calculated column like DAX below.
% OTAS = DIVIDE(SUM('Data (2)'[OTAS] ), SUM('Data (2)'[Loads] )) % OTAW = DIVIDE(SUM('Data (2)'[OTAW] ), SUM('Data (2)'[Loads] ))Then you may choose Clustered column chart to display result, put [Stop] into Axis box of chart, put the new created measures [% OTAS] and % OTAW[] into Values box.
Note that the first link you shared can't be opened, and the [Loads] can't be found in your second pbix link, while it appears in forum shared data above, so does it really exist in your data table?
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionCan you please share the sample data with column headers in it ?
Also screenshot would be nice where problem occurs and what number you are expecting..
Hi Farhan,
Please see sample data excel onedrive link and my current PB status. I am looking to make graph similer to my screen short attached bellow. I also past excel summry work which I want to make on PB and want to create graph base on this summery.
I am new to power BI and new to this forum if you need any futher detail please ask me.
Thanks
| Stop | Loads | OTAS | OTAW | OTAS % | OTAW % | ||
| 1 | 5467 | 2916 | 4786 | 53% | 88% | ||
| 2 | 4030 | 1751 | 3171 | 43% | 79% | ||
| 3 | 1638 | 611 | 1237 | 37% | 76% | ||
| 4 | 594 | 164 | 422 | 28% | 71% | ||
| 5 | 227 | 44 | 136 | 19% | 60% | ||
| 6 | 81 | 12 | 32 | 15% | 40% | ||
| 7 | 21 | 2 | 9 | 10% | 43% | ||
| 8 | 3 | 0 | 1 | 0% | 33% |