Forum Discussion
How to filter different table which doesn't have any relationship.?
I want to filter different tables which gets data from different data sources which doesn't have any relatiuonship. User will give the input in Slicer visual. From the selected value, I need to do some DAX expression and filter out the table visuals.
For Eg. Consider slicer has different dates and other tables has date column but none of the columns interlinked.
In that user will select 2 dates, According to that other visuals should get input from slicer and filter the tables.
In Qlikview, they use some Set Analysis function to get input from visuals. I want to make sure Power BI can support the same or not.
Hi Nareshbaabu,
The scenario is supported in Power BI. You can simply create a measure, and use it to apply a visual level filter(Count of Rows is greater than 0) on your table visuals. The formula(DAX) should be similar like below.
Count of Rows = VAR minDate = MIN ( 'Date'[Date] ) VAR maxDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, ( Table1[Date] <= maxDate && Table1[Date] >= minDate ) ) )In addition, here is a similar thread for your reference. :smileyhappy:
Regards
3 Replies
v-ljerr-msftMicrosoft Employee
Hi Nareshbaabu,
The scenario is supported in Power BI. You can simply create a measure, and use it to apply a visual level filter(Count of Rows is greater than 0) on your table visuals. The formula(DAX) should be similar like below.
Count of Rows = VAR minDate = MIN ( 'Date'[Date] ) VAR maxDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, ( Table1[Date] <= maxDate && Table1[Date] >= minDate ) ) )In addition, here is a similar thread for your reference. :smileyhappy:
Regards
- v-ljerr-msft
Hi Nareshbaabu,
Great to help! If the solution works, could you accept it as solution to close this thread? :smileyhappy:
Regards
