Forum Discussion

phamtrinh96's avatar
phamtrinh96
Icon for Helper II rankHelper II
7 years ago
Solved

[ Group By Number with Measure ]

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 w...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    phamtrinh96 

     

    GroupBy= CALCULATE(COUNTROWS(Sheet1), ALLEXCEPT(Sheet1, Sheet1[CustomerNumber]))
phamtrinh96's avatar
phamtrinh96
Icon for Helper II rankHelper II
7 years ago

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

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

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.