Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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]))
    RETURN
    IF(
        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!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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]))
RETURN
IF(
    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!!