Table Relationship / Two Levels Filter

[ronlolololo]

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.

[amitchandak]

@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.

[FarhanAhmed · Accepted solution]

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.

[spg_vizcube]

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 channel