Forum Discussion
Solved
ASK HELP - How To Getting Sum with distinct methods
Hi
i am asking your help to solve dax here .
i have below table
| TASK NO | COSTING |
| TASK01 | 100 |
| TASK01 | 100 |
| TASK01 | 100 |
| TASK02 | 200 |
| TASK02 | 200 |
| TASK02 | 200 |
| TASK03 | 300 |
| TASK03 | 300 |
| TASK03 | 300 |
my goal is to create measure to getting sum of costing each Task with distinct task ( due error system , duplicate detail appear ), instead of this i need to do distinct and do sum calculation. result like below table
| TASK NO | COSTING |
| TASK01 | 100 |
| TASK02 | 200 |
| TASK03 | 300 |
Thanks
SE
syaifulefendi , Create a measure like
Sumx(Summarize(Table, Table[Task], Table[Costing]), [Costing])
2 Replies
syaifulefendi , Create a measure like
Sumx(Summarize(Table, Table[Task], Table[Costing]), [Costing])
Hi, syaifulefendi
If your problem has been solved, please accept the helpful reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.
Best Regards,
Community Support Team _ Eason
