count how many unique rows with an equal sum of othe collum value

[brunoRF]

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

[Zubair_Muhammad · Accepted solution]

@brunoRF 

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