Forum Discussion
Filtering matrix rows by a column value
I've solved this with the help of Phil_Seamark comment above. Instead of using the bucket field in the columns section of the matrix, I've created a measure for each bucket using the below formulas and put that in the values:
Current = calculate(sum(Table1[$Amount]),Table1[Bucket]="Current")
30= calculate(sum(Table1[$Amount]),Table1[Bucket]="30")
etc...
Then used the Has 90 day Value filter, Has 30 day Value filter, etc. and created a tab for each bucket filter: Current filter, 30 filter, etc.
Well, after talking with the end user, the other thing I need is to be able to sort by a column in a matrix...I've seen a lot of forum posts about this and have voted for ideas on this so I'll just wait until it's something that is available to us.
I've solved this with the help of Phil_Seamark comment above. Instead of using the bucket field in the columns section of the matrix, I've created a measure for each bucket using the below formulas and put that in the values:
Current = calculate(sum(Table1[$Amount]),Table1[Bucket]="Current")
30= calculate(sum(Table1[$Amount]),Table1[Bucket]="30")
etc...
Then used the Has 90 day Value filter, Has 30 day Value filter, etc. and created a tab for each bucket filter: Current filter, 30 filter, etc.
Nice Work! :D
This worked well for me, thank you so much, wish I would have tried that earlier.
