I want to filter on measures. The way I have been doing it is with a new measure that looks like:
new measure = if(oldmeasure condition,oldmeasure,blank()). But surely, this is not how powerpivot was intended as normal people shoudl be able to do this easily without cracking out the Dax Patterns book.
Then, I want to sort on difference for ordering, but not actually show that column. Aside from hiding the column in excel (which is the cowards way), is there some other way to sort by that column without actually displaying it?
I think I figured the filtering out. You have to right click a row, not a column on the value of which you want to filter. I forgot the interface is counterintuitive