Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count

Hello Community   My data is as follows and i am expecting get the results as the last column (Lines Count) in bold letter basically i would like to display how many lines are there in a perticula...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous,

 

Modify your measure like below and try again:

Lines Count = CALCULATE(COUNT(Table1[Order#]), ALLEXCEPT(Table1, Table1[Order#]))

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Support team,

 

thanks for quick turn around..

 

I tried the below formula, it works good with lines count, but the problem is, some rows are getting duplicated, i am now getting more rows with my original data..

 

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have a join to another table, and one of the column from 2nd table is also displayed, in such cases i am getting a duplicate row for that order..

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Anonymous ,

       

      Just remove Line and #Qty column in values field.

       

       

      Community Support Team _ Jimmy Tao

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Dear Support Team

         

        as i indicated in my original request, i am getting the count when i just display the order number

        but my requirement is to the count when all the fields are in the table

         

        thanks,