Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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
@syaifulefendi , Create a measure like
Sumx(Summarize(Table, Table[Task], Table[Costing]), [Costing])
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |