[ Group By Number with Measure ]

[phamtrinh96]

Hi , I have a table 

I have 4 column CustomerNumber , TransactionDate , RestaurantCode , Amount. 

I want to create " GroupByNumber" , it is the number of "CustomerNumber" appearances. But I want to create it with Caculated "Measure".

Pls help me.

[vanessafvg]

@phamtrinh96  can you provide the data in text form, not an image?

[phamtrinh96]

Hi , This link contain file powerBI

https://drive.google.com/file/d/1QrLu6aLuFyFgHqHp5F2a2O6NPibNbkgt/view?usp=sharing

Please help me. I need to your support.

Thank you

[vanessafvg · Accepted solution]

@phamtrinh96 

GroupBy= CALCULATE(COUNTROWS(Sheet1), ALLEXCEPT(Sheet1, Sheet1[CustomerNumber]))

[phamtrinh96]

Hi , I don't see expect result , Pls check help me 

[phamtrinh96]

I want create with "measure" , not " column "

[vanessafvg]

@phamtrinh96  may i ask the issue with it being a column?  if you want to group by you will need to create a new table with summarize as far as i know if you want to incluce all the columns.