Forum Discussion
refint650
4 years agoHelper III
% Margin calculation
Hello
I'm doing % margin calculation(row total /grand total) which seem doesnt work with below dax expression always getting 100% for every row., uploaded sample data file in dropbox. I'm doing 2 step calulation
attributes are
rows : costcenter, employee, task
columns : month(time)
Measure column values
1 Task total = calculate (sum[value], values(taskname))
2) Grand total = calculate (sum[value], values(month))
3) divide (tasktotal, grandtotal).
thanks
vs
This really worked Ashish_Mathur , but i'm looking for monthly contribution % for every task,
sum of tasks/ sumof month.
3 Replies
- Ashish_MathurSuper User
- refint650Helper III
This really worked Ashish_Mathur , but i'm looking for monthly contribution % for every task,
sum of tasks/ sumof month.
- Ashish_MathurSuper User
Hi,
Try this measure
Measure 2 = divide([Values],CALCULATE([Values],all(Data[ Name]),ALL(Data[Task])))Hope this helps.