Value in column disappears after I apply a slicer filter

[veranceftw]

Hello,

I would like to understand why my

shots_on_target_against

column is disappearing after applying a simple filter to my data. These two columns belong to the same table and I just want to slice the values greater than x.

What is the problem with this?

[az38]

Hi @veranceftw 

is it calculated column?

even if no, it looks like you have some aggregation by fields. Check active Do not summarize in each field settings in Visualization Pane

[veranceftw]

Everything is as non-summarized. Same happens.

How can I have an aggregation problem? 😕

[az38]

@veranceftw 

check table in Data view

if you find more then one row for, for example, Ivan Cuellar, it will means he aggregates. and check Do not summarize here

[veranceftw]

Yes, I did that and the problem persists. I just don't know why this only happens with this particular column, all the others work as intended and they are aggregated too.

Plus, I don't know if it helps but before I slice by competition which makes each row unique (otherwise it aggregates all competitions in one). I really have no idea what is causing this.

[az38]

@veranceftw 

you can share your pbix-file on the cloud service - we will look at

[veranceftw]

I just published it to my workplace. How do I share it with you?

[az38]

@veranceftw upload your pbix for example here https://uploadfiles.io/

[veranceftw]

Here 

[az38 · Accepted solution]

@veranceftw 

if you will have a close look to all your data in data source you will see that ALL your rows with [shots_on_target_against] > 0 have an empty column [minutes_90s_gk]

and it is correct behaviour that filter [minutes_90s_gk] > 0 give you EMPTY values