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.
CaveOfWonders yes I know that 🙂 but you can use it if you know what you are doing. Didn't know about youe model before, just by the pic, what I showed will not cause ambiguity :).
You can make this a one direction and just create a measure like
CALCULTE( COUNTROWS(Reporing Periods), CROSSFILTER(Published Dashboards[ReportingDate], Reporting Dashboards[ReportingDate], BOTH) and add it to the visual level filter of the slicer to be greated then 0
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.