Forum Discussion
Running Total using multiple criteria
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.
This works to a certain extent for visuals. My problem (which I think may be too complicated) is that a lot of the data for OrderedQuantity and PONumber share the same data, whereas ReceivedQuantity differs. This is where I have been trying to do a running total to have the ReceivedQuantity column sum values associated to a condition so that way I can then take the associated OrderQuantity difference. Not sure if that makes sense.
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.
Anonymous You were right actually what I came to find out was that the division I was doing using DAX was not done correctly and the summarizing was all wrong. Thank you!