Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Proud to be a Super User!
@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.
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.
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |