Forum Discussion
Count is not matching with rows displayed in Table Visual
Super UserHi Sashank2023 your model is bad. That is why it is calculating nonsense values. Please read some basics about data modelling: e.g. here: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
This just won't work and I am not sure, what are the reasons for the tables connected like this.
Thank you, zenisekd , for helping me troubleshoot the issue. I’ve reviewed the documentation provided and attempted to use the STAR schema approach. However, I’m having trouble creating the one-to-many relationships as specified in the approach. I’m new to Power BI and trying to create a proof of concept to pitch it to my manager. Could anyone please advise me on how to optimize my model relations and make it work?
Problem: I am facing issue with displaying the total count of sort_code on a resulted table visual after applying couple of filters. I am expecting a count of 24 but, I am receiving a count of 432. Please advise.
Here is the pbix file link with sample data: https://www.filemail.com/d/gfmyjzawztthsyo
Thanks in advance!
- zenisekd
We can't help, because we don't understand, what the tables stand for .. or what is their aim. You need to at least name the tables and columns properly first.