Table and Data visulizations show wrong totals

[Anonymous]

I have 3 tables that have relationships setup.  I am tracking failure data for equipment that is catergorized into levels of importance( A, B, C, and D).  When using Table B(Catergorization Table) to filter table A I get the data I expect..64 rows with the selected infomrmation.  How ever if I use a Card visualization I get a total count of 315.  If I export the data and calcluate the numbers I get 64.  If I select to add the total to the table calulation it too will come up with 315 vs 64. 

I have tried using visulaltions to split out the data to see what it is counting to get to 315 with no luck.  I took the report down to the day and I have 1 failure but get a count of 9. I read several posts similarly related to this same thing but they either do not have a resolution or an answer at all.

[v-eachen-msft]

Hi @Anonymous ,

You could check the relationships between these tables. 

You can try to enable the option "Show items with no data" in your table visual and check if it show 315 records.

[Anonymous · Accepted solution]

I modified my query to get the specifics results needed and used this to apply to the rest of my visuals.   I still believe there is a larger issue at hand but do not have the time to look it to this properly at the given time.  If/when I do I will post my findings.  I appreciate everyones assistance and guidiance. 

Thanks, 

Gary

[Anonymous]

Thank you for your response.  I had checked the relations between the table and even simplified the relatiosn by isolating the data and that was all good.  I could kind of replicate a similar issue when filtering the data for condition A and counting the number of occurreneces for that day.   Instaead of giving me the count on the fitlered results it would apply the logic of the filter and then any result that matched the date of the filter set would then be counted as well.  I had written my initial query to pull more data  than was needed by this particular visual as I wanted to create other visuals but ended up creating a query just for this visual and use it now as my fitler for the more general query which seems to be working without issue.  

[edhans]

Can you share your PBIX via OneDrive? I suspect there is an issue going on with your relationships and how your measures are being written where one table is not filtering another as you expect, but without access to data and how the model is set up, I'm speculating, and even if I'm right, cannot be more specific than that.

[Anonymous]

Thank you for the response.  I ended doing the calcutation via my SQL query which gave me what I was looking for.  I still think something is broken in some of  the logic Power BI  applies due to the fact that the exported data row count matches exactly what number I expect so the "count card" should reflect the same information. 

[Anonymous]

I can not share the data in it's entirety but I will see if I can recreate it and get similar results...It may even help me resolve it myself.  I didn't know if maybe there was a basic gotcha that I have been too dense to catch yet.  I really appreicate the quick respone and will get back with the new data and anything learned. 

What blows my mind is that the table visual with 64 1s showing showing in the first column  gives a total of 315.