Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I would like to know how many customer have done some total TX. Is it possilble with a measure.
I want to get to the 2 table from the 1 table. For instance I want to see that the only 1 customer did 7 TXs (4444); only two customers (2222 & 1111) have done 6 etc.... Thankss in advance
Solved! Go to Solution.
Try adding a calculated column for TX count like
TX COUNT =CALCULATE(sum(Table1[Transaction]),ALLEXCEPT(Table1,Table1[Customer ID]))
Then you can place the TX Count in a Table Visual alongwith DistinctCount of Customer ID
Try adding a calculated column for TX count like
TX COUNT =CALCULATE(sum(Table1[Transaction]),ALLEXCEPT(Table1,Table1[Customer ID]))
Then you can place the TX Count in a Table Visual alongwith DistinctCount of Customer ID
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |