Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 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 Team

     

    If 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

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous - for questions like this, it's always helpful to have a data model to play with. Could you create a simplifed version of your data model with fabricated data and sample visuals in a way that replicates the error you're seeing, and post it so we can download?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    RMDNA
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Anonymous usually users upload them to OneDrive/Google Drive/etc. and share a download link