Measure Undoing Filter

[Anonymous]

I have 2 tables with a many to one relationship, and when I filter the one table, the many table filters just fine, until I add a measure that exists in the many table. It just undoes the filter that I applied and I have no idea why, any idea what's going on and how to fix it. Thanks!

[amitchandak · Accepted solution]

@Anonymous , does filter uses all, removefilters etc? That can do that.

can you share the measure's formula ?

[Anonymous]

Not currently, I have an all except condition but for the specific groups, but that's it.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

I actually just discovered that the issue was replacing blank values with 0, not sure how to reconcile this issue.