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.
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.
This worked well for me, thank you so much, wish I would have tried that earlier.