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.
Hey Anonymous
This is where Power BI shines. Assuming I understand your problem correctly I believe what you need is a table (or matrix) accompanied by multiple slicers.
First off, for your difference, you can simply create a calculated column = OrderedQuantity - ReceivedQuantity
Then create a table visual with all of your highlighted and underlined columns (as well as the new calculated column).
Then create slicers for the item number and vendor name
For a date (timeline) slicer I recommend using the one in this link: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview. This is where you will use ItemArrivedJournalDate.
Using these slicers will dynamically filter your table and the calculated column for whatever selection you make. Let me know if this helps.
If this helps please kudo.
If this solves your problem please accept it as a solution.
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!