Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Unity
Frequent Visitor

DAX Calculate Filtering Issue - Aggregate Wrong, Data Correct?

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))
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Not applicable

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

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

 

Capture.PNG

How would you reccomend I do the context transition?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors