Forum Discussion
Exclude Certain Values from Filter based on logic from Disconnected Table
- 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.
Thank you so much dude 🙂🙂🙂🙂🙂🙂🙂🙂🙂🙂🙂
- SpartaBI4 years agoCommunity Champion
CaveOfWonders my please friend 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂