How to slice between fact tables with a dimension that is not available in one of the them

[I_LOVE_POWER_BI]

Dear community,

I believe I have a simple problem here, but I am just not far enough with my DAX skills yet, please help me out.

So what I want to do with a short fake example:

I have two fact tables: Price and Receipies. There is a column which is used in both (Ingredients), so I use a dimension table with unique values in the column ingredients to slice through both tables - so far so good.

However, now I want to use the column "Receipe" in my Fact_Receipes table in order to slice my table as shown in the "Goal Report". Obviously, the filter direction goes from Dim_Ingredients to the fact tables, therefore the filter doesn't work.

As I learned bi-directional filtering isn't the best option since it could lead to ambiguity (and this model is only an example, the actual one is more complex). So I think about CROSSFILTER or something, but have no experience how to build it up. 

Thanks for your support! 

[amitchandak · Accepted solution]

@I_LOVE_POWER_BI , Create measure on Receipies say

M1= countrows(Receipies) 

and use that as visual level filter

M1 is not blank and check if that can help

[I_LOVE_POWER_BI]

@amitchandak I gave it another try and it actually works! However I do not understand why...could you explain how the Power PI engine is doing it? Thanks!

[I_LOVE_POWER_BI]

@amitchandak thanks a lot for your reply! It works in regards that I now only see those entries that are available in my receipe fact table. However, my goal is to slice based on the column receipe, e.g. by "Apple Cake" - therefore the solution you suggested is not enough. Therefore I guess the solution is a bit more complex... 😞 Thanks again for more ideas!