Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I wanted to a create a measure which will do SUM(Distincts [Points]) GROUP BY Transaction_Id in DAX for the given sample data below
Transaction_Id | Points |
1 | 1650 |
1 | 1650 |
1 | 1650 |
2 | 1250 |
2 | 1250 |
2 | 1250 |
Please can you help me with the DAX command.
Regards,
Ranjan
Solved! Go to Solution.
Hi, @Anonymous
Please correct me if I wrongly understand your question.
Please try the below measure.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please correct me if I wrongly understand your question.
Please try the below measure.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |