Mike_Alex
New member
I am a little stumped by something that seems fairly easy to do! I am working with PowerPivot, and have a large list of items. I can return the data easily enough to a pivot table, but what if I want to filter it first. I have looked thru multiple DAX formulas, and see the filters and the calculate and such, but here is the problem, (ref table below). All I want to do is know how may item A’s I have in multiple stores, and only count it once:
Seems easy enough, how many item "A"s do I have? I have 3, in two stores, but I still only have three. I would like to know I have three of the Item "A"s on one report, and would like to know that Item "A" lies in two stores on another report. But How can I put that in PowerPivot? This may seem visually easy, but in the PowerPivot, I have hundreds of thousands of items, spanning across up to eight stores.
Any Ideas? Would be greatly appreciated...
:frusty:
Item ID | Store A Quantity | Store B Quantity |
A | 1 | |
A | 2 | |
B | 1 | |
C | 5 |
Seems easy enough, how many item "A"s do I have? I have 3, in two stores, but I still only have three. I would like to know I have three of the Item "A"s on one report, and would like to know that Item "A" lies in two stores on another report. But How can I put that in PowerPivot? This may seem visually easy, but in the PowerPivot, I have hundreds of thousands of items, spanning across up to eight stores.
Any Ideas? Would be greatly appreciated...
:frusty: