Forum Discussion
Table Relationship / Two Levels Filter
Hi team, I am experiencing this issue and would like to know why this is happening. There are three tables: State - County - Cases. I want to see the cases by states. I could achieve this by using County table and Cases Table, but if I use State table and Cases Table. It shows 'blank'. But if I use State table to filter County table, it actually works fine. Wondering why this happening. Thanks.
1- Check your relationship between State/County as they both joined on same column data.
2- Any missing join brings null to data, so make sure all States defined in County are available in State table.
3 Replies
Hi,
This may be happening because your crpss filter direction is set to Single between the relationship from County to States to Cases. Try that it should work
Appreciate your Kudos!
If I solve your problem, please accept this as a Solution
Add me on Linked In , Visit my blog vizcube.biz
Subscribe to my youtube channel1- Check your relationship between State/County as they both joined on same column data.
2- Any missing join brings null to data, so make sure all States defined in County are available in State table.
ronlolololo , looking at relation it should work. , Unless there is missing data in the state table. Does the state table has all the required values.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
