topic Re: DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct? in DAX Commands and Tips

DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

Unity — Wed, 03 Jul 2019 17:01:09 GMT

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))

Re: DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

Anonymous — Thu, 04 Jul 2019 23:36:57 GMT

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

Re: DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

Unity — Mon, 08 Jul 2019 15:55:32 GMT

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?

Re: DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

Anonymous — Mon, 08 Jul 2019 17:00:00 GMT

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