DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

[Unity]

I am using two DAX measures; Measure 1 works fine. Measure 2 shows the same aggregate as Measure 1. However, Measure 2 displays the correct values in a table (except for the total).

I'm guessing I did not set the filter ideally, or have a problem filtering on the result?

Measure1 = CALCULATE(DISTINCTCOUNT('Table'[ID]), 'Table'[Summary] <> "X")

Measure2 = CALCULATE(DISTINCTCOUNT('Table'[ID]), 'Table'[Summary] <> "X", FILTER('Table', COUNT('Table'[ID]) > 1))

[Anonymous]

Please paste some screenshots of your model and tell us what you want Measure2 to do... It's not clear what you want it to do at this point. If you can, please give us a CLEAR explanation of how the measure should work.

Thanks.

Best

Darek

[Anonymous · Accepted solution]

Mate, would you mind posting some kind of screenshot of what the issue is you're talking about? Why do you want these two measures to return the same values?

By the way, using

	filter(
		'Table',
		COUNT( Table[ID] ) > 1
	)

executes COUNT(...) without context transition and - depending on what you have in the Table - it does not filter anything or filters out everything. But why the two measures return different values I can't tell since I can't see where and how they're being used.

Best

Darek

[Unity]

They are supposed to return different results. They do on a data level, but not on a total level.

How would you reccomend I do the context transition?