Forum Discussion
Anonymous
3 years agoNot applicable
Date Table doesn't filter charts properly
Hello, i have an issue with a Date Table. I have a simple Table with unique IDs, some attribute columns and an 1:many relationship to a DateTable. If i create a Table visual with columns from the or...
- Anonymous3 years ago
Hi Anonymous ,
The cross-filter needs to be changed to Both:count of artrfactid = CALCULATE(COUNT('Table1'[ArtefactId]),CROSSFILTER('Table2'[ArtefactId],'Table1'[ArtefactId],Both))Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Anonymous
3 years agoNot applicable
Hello, RMDNA and thank you for your answer. I manage to create a sample pbix file and indeed seems to have the same problem. Where can i give you the file?
RMDNA
Solution Sage
3 years agoAnonymous usually users upload them to OneDrive/Google Drive/etc. and share a download link