Forum Discussion
Helper VRow wise calculation in percentage
Helper V
Community Champion
link:
https://drive.google.com/file/d/1gxq7LrYwLHp0_o9owqj3g3mVO9GNAyza/view?usp=sharing
kindly check the above link and download the solution.
summary :
creating measure which check if category = " gross profi rate" , it uses format function to format the value as % ) .
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
- NadeemAhamed
Thank your suggestion.
Requirement:
From sales dept i will receive only Plan and Actual values for category and division wise.
1. I have to calculate Variance(Actual - Plan) and Achievement (Actual/Plan) Values in seprate column, that is resolved.
2. I have calculate "Gross Profit Rate" value from "Gross Profit/Sales" and have to place after Gross Profit Row to pertcular Plan, Actual, Variance and Achievement Columns in percentage.
3. When we are selecting multiple division "Gross Profit Rate" value should not get sum, it should be take the current "Sales and Gross Profit" values for calucation.
- Daniel29195
Kindly check the below
https://drive.google.com/file/d/1wDjBlJuGmvsVFyctYWJH9JuaRNrjoEsk/view?usp=sharing
let me know if this works for you .
- NadeemAhamed
Dear Daniel29195
Sorry for saying this,
As per the pbix i think you have taken the values from the table it self.
Where i want to calculate the values in Power BI. as from the sale person we are not going to get that values.