Forum Discussion
Exclude Certain Values from Filter based on logic from Disconnected Table
CaveOfWonders it's hard to understand 🙂 It depends on where you select and choose filters on the projects. If it's on the dim, then of course no but you can achive it by adding to my measure something like:
CALCULTE( COUNTROWS(Reporing Periods), CROSSFILTER(Published Dashboards[ReportingDate], Reporting Dashboards[ReportingDate], BOTH), TREATAS(VALUES(Projects[[Project ID]), Published Dashboards[Project ID]).
You need to test it, I doesn't have all the data on your model. Hope that the answer you need.
Thank you SpartaBI . Appreciate your help on this. Does that measure also take into consideration the Project being selected? There are 2 conditions to be met, one is the project id's have to match and the second is the dates have to match and then the flag has to be 1, i.e. yes.
CaveOfWonders it's hard to understand 🙂 It depends on where you select and choose filters on the projects. If it's on the dim, then of course no but you can achive it by adding to my measure something like:
CALCULTE( COUNTROWS(Reporing Periods), CROSSFILTER(Published Dashboards[ReportingDate], Reporting Dashboards[ReportingDate], BOTH), TREATAS(VALUES(Projects[[Project ID]), Published Dashboards[Project ID]).
You need to test it, I doesn't have all the data on your model. Hope that the answer you need.
Okay, thank you :). I will test and get back to you with the resutls. Hopefully it works. I've been struggling with this all afternoon.
SpartaBI
Tested: Not Working. Getting the following error:CaveOfWonders you need to create that relatinship I showed in my original picture of course 🙂 and it can be one direction because we will use that measure on the visual level filter of the slicer.
SpartaBI I created the relationship as advised:
Measure being used:
measure = CALCULATE ( COUNTROWS ( 'Reporting Periods' ), CROSSFILTER ( 'Published Dashboards'[Reporting Date], 'Reporting Periods'[ReportingDate], BOTH ), TREATAS ( VALUES ( Projects[Project ID] ), 'Published Dashboards'[Project ID] ) )but not working as expected. Project 7 should only have the 14th April and 9th June in the filter. The measure is counting a 1 for them all.