Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
It can only filter on column [StatusVlookup]. You may drag the calculated column below to Rows.
Column = 'Table'[Issue logged date] <= TODAY () - 60
It can only filter on column [StatusVlookup]. You may drag the calculated column below to Rows.
Column = 'Table'[Issue logged date] <= TODAY () - 60
Drag the calculated column to Rows of the Matrix visual.
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
How about placing the measure you already have [open since 60 days], that seems to be working fine, on the visual level filters of the table visual you have in your report and then selecting 'Show items when the value:' is not zero?
That should do the trick
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |