Incorrect Count Value

[sheilarizky]

Hi,

I have three different raw data files with three same columns (SKU Name, Branch, Store) so I created a star schema for each table and I have joined all three of them to my all three raw data files through Manage Relationship function. The output that I want is when I filter a branch & SKU Name, the number of clinic that shows up in my raw data for the choosen branch & SKU name will show up in a card. When I tried it in a table, with columns (SKU Name, Branch, Clinic Code) all from my star schema table, it returns the correct value just fine. However, when I choose to count the clinic code instead, it returns an incorrect value. I attach the screenshot of it.

I just can't figure out where I did wrong because only the count function returns the incorrect value but it works fine if I just choose to show the clinic code without the count function.

Thank you so much in advance

[arvindsingh802]

It seems common issue with Matrix total 
Please refer https://community.fabric.microsoft.com/t5/Power-Query/Incorrect-Column-Totals-in-Matrix/td-p/2775762 for quick fix

[sheilarizky]

Hi,

Thanks for your answer but I'm not sure if that's the answer I'm looking for because I actually didn't use any measure to show the count value as it actually returned the correct value if I choose to not summarized it. I only choose to show it as a 'Count' on my Visualizations page. I tried using a measure with formula COUNT() and it still returned the exact same value. 

I also have tried following this step and it still returned the same incorrect value.

https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/5...

I'm not dealing with the total value yet right now because the count value per row is incorrect already. Only the count value is wrong and not the real value as in the Clinic Code value because it returns the correct value