Forum Discussion
Helper IIMeasure in Matrix is not able to Filter the main table even after fixing Edit-interaction
I have this measure which provide me list of "Open Issues" older than 60 days. I was using this measure as a Card to display the Count of days, but since the card doesn't filter the Table, so I decided to use the measure in Matrix. So when I click the number displayed in Matrix, the Table is expected to filter and display only those items older than 60 days
Measure: Issues open since 60 days = var _count=CALCULATE(COUNTROWS(Table),Table[StatusVlookup] = "Open Issues" , Table[Issue log date]<=TODAY()-60) return IF(ISBLANK(_count),0,_count)
Problem is the Table isn't filtering the Open issues let alone selecting Older than 60 days. It is also selecting Closed issues. Please advise how can we resolve this?
It can only filter on column [StatusVlookup]. You may drag the calculated column below to Rows.
Column = 'Table'[Issue logged date] <= TODAY () - 60
12 Replies
ymirzaI will attach the file- AlB
Community Champion
You can post here the URL to the file, either from platforms like OneDrive, Dropbox... or upload the file to sites like http://www.tinyupload.com/ or https://www.filedropper.com/ (no sign-in required) and share the URL
v-chuncz-msftCommunity Support
It can only filter on column [StatusVlookup]. You may drag the calculated column below to Rows.
Column = 'Table'[Issue logged date] <= TODAY () - 60- ymirzaI have added this Column in the main table, it is giving me True and false values. True = older than 60 days. But how will the main table filter the True values when i click on the matrix table. Did you download the pbix i sent for reference in the google drive link?
- v-chuncz-msft
