Lets say I have a list of PO's, over 30,000, into the company for the last year, covering around 6500 parts. Some of the parts have up to 4 suppliers and I want to quickly show no suppliers, COUNT(DISTINCT Vendor) and then show the average price for each of the vendors in a simple table. What is the best way to go about this. I've been looking at FirstSortedValue, and ranking but haven't figured it out yet? Any ideas?
I didn't manage to get it into one row per [Item] (FirstSortedValue() returns Null() if more values share the first rank, Rank() trials only worked for the first Vendor/Qty/Avg Price). But maybe this solution using dimension limits will suit you.