Forum Discussion
Measure breaks inner join
There are no "inner joins" in the same sense there are inner joins with SQL. DAX joins are different. When the arrow points both ways, it is bi-directional cross filtering. The arrow indicates how filters flow, it doesn't limit data. You'd need to use Inner Join in Power Query to actually limit data.
You should probably read this article by SQLBI on joins in DAX, including a description of how the NATURALINNERJOIN() function works.
You may also want to see if CROSSFILTER() will help in your measure to activate cross filtering in a specific measure without forcing a bidirectional relationship, which can cause problems down the road.
Community ChampionThere are no "inner joins" in the same sense there are inner joins with SQL. DAX joins are different. When the arrow points both ways, it is bi-directional cross filtering. The arrow indicates how filters flow, it doesn't limit data. You'd need to use Inner Join in Power Query to actually limit data.
You should probably read this article by SQLBI on joins in DAX, including a description of how the NATURALINNERJOIN() function works.
You may also want to see if CROSSFILTER() will help in your measure to activate cross filtering in a specific measure without forcing a bidirectional relationship, which can cause problems down the road.
That's helpful. Reading that link led me to a solution. I had to create a measure to check if TY Sales or LY Sales were greater than 0. Then I included that in the filter.