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.
Your filter path of Designation Status -><- FIPS -> Sales, should work in theory, but you’re applying filters from both Designation and FIPS at the same time, while they represent the same grain (county). That creates an intersection of filters across two related dimension tables and if there’s even a slight mismatch like duplicates in FIPS, missing counties or non-identical keys, the result is an empty filter context, which shows as blank. This is exactly what your card is doing.
I suggest you stop using two tables to filter the same thing. Keep FIPS as your single dimension, merge the Y/N status into and relate FIPS (1) -> Sales (*) on MergedCounty_State. Then filter only on FIPS[Status] = "Y".
Helper III am still having trouble. I tried using the designation table mergedCounty_State to the Sales table mergedCounty_State - and in the card visual, if I add the designation status and filter by "no" - I get a dollar amount, but if I filter "yes", I still see "--"
Not sure what that means?
- v-hashadapu
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.
- W2SANC
Thank you! This was the issue!!!