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...
- 4 years ago
- 4 years ago
This really worked Ashish_Mathur , but i'm looking for monthly contribution % for every task,
sum of tasks/ sumof month.
Ashish_Mathur
4 years agoSuper User
- refint6504 years agoHelper III
This really worked Ashish_Mathur , but i'm looking for monthly contribution % for every task,
sum of tasks/ sumof month.
- Ashish_Mathur4 years agoSuper User
Hi,
Try this measure
Measure 2 = divide([Values],CALCULATE([Values],all(Data[ Name]),ALL(Data[Task])))Hope this helps.