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.
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.
CaveOfWonders The measure is only meant to put on the visual level filter of the slicer.
Also, regaring the other filter, is it applied:
CaveOfWonders I will PM you
CaveOfWonders can you PM me now, for some reason I don't have a message you button on your profile
When I apply that filter to the page filter nothing appears in the drop down.
I think I've just resolved it now (with your help of course). I added a relationship to the project table and excluded 0's from the display flag column in power query and it seems to have done the trick. I can't thank you enough. Oh also, I added = 1 instead of > 1 in the filter.