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]))
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

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