Summarize Table is not filtering with the slicer

[Akhil_1411]

Hi All,

1. I have created summarize table with cutomers and sum of their disounts. 

2. Created the relationship with the main table and summarized table with customer  which is many to one.

3. I have applied a year slicer from the main table, the summarize table is not filtering.

Can anyone suggest me where i am going wrong or any suggestions.

Adding the file you can download : https://we.tl/t-Rn8KOEY6cE 

Thanks,

Akhil.

[v-jayw-msft · Accepted solution]

Hi @Akhil_1411 ,

The summarize table won't be filtered in your model because it's a calculated table not a visual.

Try add year column in your summarize table.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Akhil_1411]

Hi,

One can download the file here: https://we.tl/t-Rn8KOEY6cE 

Thanks,

Akhil.

[az38]

@Akhil_1411 

whats direction of your relationships? set as both

[Akhil_1411]

@az38 ,

I tried using both and single direction but results are not as expected when i slicer with year.

Thanks,

Akhil.