Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running Total using multiple criteria

Good Morning All,    Hoping to get you help on something that has been defeating me as of late. I have a data set of On-Time Delivery for my company and what I am hoping to acheive is being able to...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Yeah I'm not understanding. As long as you are making sure your values in the visual are summing and not counting it shouldn't matter if the data is different as the visual function like pivot tables in excel.

     

    aNd if you need the count, just make sure it isn't using dinstinct count.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Would you like something below:

If so, please create measures

running total_r =
CALCULATE (
    SUM ( 'Table'[ReceivedQuantity] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Vendor Name]
            = MAX ( 'Table'[Vendor Name] )
            && 'Table'[ItemNumber]
                = MAX ( 'Table'[ItemNumber] )
            && 'Table'[Date]
                <= MAX ( 'Table'[Date] )
    )

running total_O =
CALCULATE (
    SUM ( 'Table'[OrderedQuantity] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Vendor Name]
            = MAX ( 'Table'[Vendor Name] )
            && 'Table'[ItemNumber]
                = MAX ( 'Table'[ItemNumber] )
            && 'Table'[Date]
                <= MAX ( 'Table'[Date] )
    )

diff = [running total_r]-[running total_O]

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.