Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |