Hello!
I am working with a large amount of expense data in PowerPivot, and was wondering if there was a way to create a measure or filter or something that would aggregate and sum all values less than $10,000 into a single row ("Other Expenses," or something like that)
I have experimented a bit with CALCULATE() and SUMX(), but they don't seem to like my "<10000" Any help or advice would be greatly appreciated.
I am working with a large amount of expense data in PowerPivot, and was wondering if there was a way to create a measure or filter or something that would aggregate and sum all values less than $10,000 into a single row ("Other Expenses," or something like that)
I have experimented a bit with CALCULATE() and SUMX(), but they don't seem to like my "<10000" Any help or advice would be greatly appreciated.
