Forum Discussion
Display rows in visual matrix with a value
Hello All,
I have the below visual matrix.
The Overdue Test column is a measure:
Overdue Test = CALCULATE(COUNTROWS(FactChanges), KEEPFILTERS(FactChanges[Days Overdue] > 5), KEEPFILTERS(FactChanges[State] in {"Open", "Work In Progress"}), KEEPFILTERS(FactChanges[Approval state] in {"Approved", "Pending CAB", "Retrospective"}))
I need this report to only show rows with the value of '1'. The rows displayed should be '15'.
Any help on how I can solve this would be greatly appreciated.
Hi Anonymous ,
You can use your measure Overdue Test as a visual level filter in your matrix visual where you can set
Overdue Test = 1
Thanks,
Pragati
3 Replies
Hi Anonymous ,
You can use your measure Overdue Test as a visual level filter in your matrix visual where you can set
Overdue Test = 1
Thanks,
Pragati