Forum Discussion

clarkey1988's avatar
clarkey1988
Helper II
5 years ago
Solved

Count Rows based on a value in a column

Hi,   I'm wondering if anyone can help.   I am trying to divide the $ amount in route revenue evenly by the number of rows an order header number has.   So in the first example below it would b...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi clarkey1988 

    Try this for a calc column:

    Split Revenue V2 =
DIVIDE (
    Table1[Route Revenue],
    CALCULATE (
        COUNT ( Table1[ord_hdrnumber] ),
        ALLEXCEPT ( Table1, Table1[ord_hdrnumber] )
    )
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi clarkey1988 

Try this for a calc column:

Split Revenue V2 =
DIVIDE (
    Table1[Route Revenue],
    CALCULATE (
        COUNT ( Table1[ord_hdrnumber] ),
        ALLEXCEPT ( Table1, Table1[ord_hdrnumber] )
    )
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

clarkey1988's avatar
clarkey1988
Helper II
5 years ago

Hi AlB , I appreciate your help.

 

That worked. I received your message and will respond. I do have a quick follow up. I believ eit's similar to the above.

 

I have a specific route number called Nestle-12 that I invoice $14,100 each week. I again need to divide this $14,100 by the number of orders for Nestle-12 for that given week. So the example below would be $14,100/9 = $1,566.67 each row.

 

It's similar to the above but it's specific to a route number and week number.