Forum Discussion
Helper IIHelp With Semantic Model - Different Sums & Counts for Sales in Specific Counties From Total Sales
Hi W2SANC , Thank you for reaching out to the Microsoft Community Forum.
I think this is a data mismatch issue. Since No returns a value but Yes shows “--”, it means the filter is working, but none of the Y counties are matching any rows in Sales under your join key. I suggest you check a few Y counties from the designation table and verify that the exact same MergedCounty_State values exist in Sales, make sure to watch for spacing, casing and formatting differences. If they don’t match exactly or those counties aren’t present in Sales, you’ll get this behavior.
Community SupportHi W2SANC , Thank you for reaching out to the Microsoft Community Forum.
I think this is a data mismatch issue. Since No returns a value but Yes shows “--”, it means the filter is working, but none of the Y counties are matching any rows in Sales under your join key. I suggest you check a few Y counties from the designation table and verify that the exact same MergedCounty_State values exist in Sales, make sure to watch for spacing, casing and formatting differences. If they don’t match exactly or those counties aren’t present in Sales, you’ll get this behavior.
Helper IIThank you! This was the issue!!!