Filter the data by a field that is not in the visualization

[EstherBR]

Hi, 

I have the following data model:

and the following visualizations:

In Both visualizations the following filter is applied:

The issue is that the filter applies to Sales per ID visualization, but it does not apply correctly to the Sales per city ID. It takes into consideration all Sales even if they are lower than 101. How can I add that filter to the Sales per ID visualization? Thanks!

[V-yubandi-msft]

Hi @EstherBR ,

@cengizhanarslan , has correctly pointed out the issue and shared a few steps to follow. Have you tried those steps, and did they help? If you are still facing any issues or need additional information, please let us know.

Thanks for your valuable response @cengizhanarslan  .

Regards,

Yugandhar.

[cengizhanarslan · Accepted solution]

Create a proper key relationship so the City table can filter Fact rows by ID:

• DimLocation[ID] (unique) 1 →* FactSales[ID]

• Keep Country/City as attributes of the dimension, not the join key.

This makes any filter by ID naturally flow to City aggregates.