Forum Discussion

Federico92's avatar
Federico92
New Member
5 years ago
Solved

Running Count for Selected Values

Hi everyone, I'm new to power by and I want to obtain this results from my data   What I want to do is a running count based on the value in fields "Assigned To" that is numerically sorte...
Need Help
  • mwegener's avatar
    mwegener
    5 years ago

    Hi Federico92 ,

    this seems to work.

    Count =
VAR OrderID = 'Sample Data'[Order]
RETURN
    CALCULATE (
        COUNTROWS ( 'Sample Data' ),
        FILTER (
            ALLEXCEPT ( 'Sample Data', 'Sample Data'[Group] ),
            'Sample Data'[Order] <= OrderID
        )
    )

     

     

mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

Hi Federico92 ,

can you provide sample data and describe which column is used for sorting?
In the image with the expected result, I don't see any reference to the "Assigned To" column.

 

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      5 years ago

      Hi Federico92 ,

      this seems to work.

      Count =
VAR OrderID = 'Sample Data'[Order]
RETURN
    CALCULATE (
        COUNTROWS ( 'Sample Data' ),
        FILTER (
            ALLEXCEPT ( 'Sample Data', 'Sample Data'[Group] ),
            'Sample Data'[Order] <= OrderID
        )
    )