Forum Discussion

phamtrinh96's avatar
phamtrinh96
Helper 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]))
vanessafvg's avatar
vanessafvg
Community Champion
7 years ago

phamtrinh96 

 

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

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

  • phamtrinh96's avatar
    phamtrinh96
    Helper II
    7 years ago

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

    • vanessafvg's avatar
      vanessafvg
      Community 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.