Forum Discussion
Count Distinct in visual issue
Hi all, hope you can help me with this. I am trying to have a card visual where I want to count product numbers from a dataset, uploaded through a query. The issue is with the visual when...
Hi Anonymous
I would recommend not having the relationship set to cross-filter direction to both, this can cause issues with numbers, due to the probability of one of the tables being filtered by another.
Thsi article may help you with setting up your data model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
To help you further, please provide more info or a screenshot of the relationships in your model and what each table is.
Joe