Basic : Data Model Question

[digitalau]

I have a very basic Data Model Question . 

I have multiple tables connected with Date . However, there are other fields I want to use while filtering . 

There's a Calculated Column In ImpressionShare Table , _campaignType 

_campaignType =

IF(

CONTAINSSTRING(ImpressionShare[Campaign name],"Exact"),

"Exact Match",

IF(

CONTAINSSTRING(ImpressionShare[Campaign name],"Broad"),

"Broad Match",

"Others"

))

The problem with not being able to link multiple tables with Campaign / AdGroup is that I have to create Calculated Columns in Each table. 

And then for each new Page , I will have to choose different filters which will need individual selection on every page.

There must be a better way of doing it which I am not familiar with

Can you please let me know what would be better approach in creating calculated column( using green highlighted column )  once and then using it across all tables . 

[v-xuding-msft]

Hi @digitalau ,

Do you solve the problem? Can the way that change the cross filter direction help you?  If so, please mark the helpful answer to as a solution. More people will benefit here. If not, feel free to ask. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @digitalau ,

Do you try to change the cross filter direction from single to both? In this way, the three tables will be connected together. They will be filtered by the same values.

You could reference the blog : What is the Direction of Relationship in Power BI? to understand the direction clearly. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.