Relationship & Filtering - Tables Not Filtering as Expected

Hey Anonymous ,

I have an answer for your second question (at least in a simplified model).

Change the behavior of the dimension table in the table visualization to "Show items with no data"

and the row stays in the data visualization:

To provide an answer to your first question, I recommend that you create a pbix file that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures), upload the file to OneDrive, Google Drive,  or dropbox and share the link. If you use a spreadsheet to create the sample data instead of the manual input method, share the spreadsheet too.

If I have sample data, I consider it simpler to provide answers to data modeling (here) and DAX questions because this prevents confusion in understanding.

Do not forget to describe your challenge/issue based on the sample data you are providing.

I'm wondering why you have created relationships between the dimension tables (calendar and campaigns) and the conversion fact table, because you state "I'm expecting the Campaign table to filter the Ads table, which would then filter the Conversions table." From my understanding the relationships between dim and conversion are not required.

Here you will find my simplified example that might help to answer your second question: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/Ee2pI8xgUwlFiMLtArQSQXIBDi8yD_DMFjTUAIq9A7Vibg?e=GHq3vp

Regards,

Tom