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.