Forum Discussion
Filtering a Table from Unconnected table
Please see attached PBIX
https://1drv.ms/u/s!AlMdRxAveLesgegBXfqFY0rPLElZcA?e=bcP2cP
Here is my simple dataset:
| Name | Days from Closed Date | ||
| A | 15 | ||
| B | 87 | ||
| C | 101 | ||
| D | 190 | ||
| E | 280 | ||
| F | 590 | ||
I want to filter table by a Period table
Here are the expected results:
1. If Period 28 days (<= 28 days) days Selected,
| Name | Days from Closed Date | ||
| A | 15 |
2. If Period 3 Months (<= 90 days) Selected
| Name | Days from Closed Date | |
| A | 15 | |
| B | 87 |
3. If Period 1 Year (<= 365 days) is Selected
| Name | Days from Closed Date |
| A | 15 |
| B | 87 |
| C | 101 |
| D | 190 |
| E | 280 |
Hi Anonymous - When selecting a period from an unconnected table (Table B) filters the data from Table A,
I have create a measure for selected period B
SelectedPeriodDays =SELECTEDVALUE('CPeriod'[Days], MAX('CPeriod'[Days]))Create another measure that determines if the rows in Table A should be displayed based selection period as below:
ShowRows =VAR SelectedDays = SELECTEDVALUE('Cperiod'[Days], MAX('Cperiod'[Days]))RETURNIF(MAX('CDT'[Days from Closed Date]) <= SelectedDays,1,0)Choose a table chart, apply the visual level filter by using a measure ShowRows is 1
add period field on report with slicer chart and select the conditions, it works as expected. please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 Reply
- rajendraongole1
Super User
Hi Anonymous - When selecting a period from an unconnected table (Table B) filters the data from Table A,
I have create a measure for selected period B
SelectedPeriodDays =SELECTEDVALUE('CPeriod'[Days], MAX('CPeriod'[Days]))Create another measure that determines if the rows in Table A should be displayed based selection period as below:
ShowRows =VAR SelectedDays = SELECTEDVALUE('Cperiod'[Days], MAX('Cperiod'[Days]))RETURNIF(MAX('CDT'[Days from Closed Date]) <= SelectedDays,1,0)Choose a table chart, apply the visual level filter by using a measure ShowRows is 1
add period field on report with slicer chart and select the conditions, it works as expected. please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!