cancel
Showing results for 
Search instead for 
Did you mean: 
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

View solution in original post

Unity
Frequent Visitor

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors