Forum Discussion

CaveOfWonders's avatar
CaveOfWonders
Helper IV
4 years ago
Solved

Exclude Certain Values from Filter based on logic from Disconnected Table

Hi All,   Struggling with this one.   Please use this link (PBIX File ) to download the pbix file for ease of understanding/answering my question.   I have 3 dimension tables and one fact table...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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.