Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Removing post.
Hi, @dochtang
MIN GUNBARREL X = CALCULATE(
                    MIN('All Wellbores'[Gunbarrel X]),
     allselected('All Wellbores'[shortname])
                   
                    )
or
MIN GUNBARREL X = 
minx(
     allselected('All Wellbores'),
      'All Wellbores'[Gunbarrel X] 
     )
 
Removing post.
HI, @dochtang 
try below code 
MIN GUNBARREL X = CALCULATE(
                    MIN('All Wellbores'[Gunbarrel X]),
     removefilters('All Wellbores'[shortname])
                   
                    )
hello @dochtang , why not tru using minx?
MIN GUNBARREL X = MINX(ALL('All Wellbores'), 'All Wellbores'[Gunbarrel X])
					
				
			
			
				
			
			
				
			
			
			
			
			
			
		Removing post
i see i used
ALL('All Wellbores')
try using only
'All Wellbores'
so 
MIN GUNBARREL X = MINX('All Wellbores', 'All Wellbores'[Gunbarrel X])
Removing
can you please try 
MIN GUNBARREL X = 
MINX(
    FILTER('All Wellbores', 'All Wellbores'[ID] = SELECTEDVALUE('YourSlicerTableName'[ID])),
    'All Wellbores'[Gunbarrel X]
)
if it doesnt work please share some sample data
Removing
MIN GUNBARREL X = 
VAR SelectedIDs = VALUES('YourSlicerTableName'[shortname])
RETURN
MINX(
    FILTER('All Wellbores', 'All Wellbores'[shortname] IN SelectedIDs),
    'All Wellbores'[Gunbarrel X]
)
					
				
			
			
				
			
			
				
			
			
			
			
			
			
		Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | 
| User | Count | 
|---|---|
| 24 | |
| 11 | |
| 11 | |
| 9 | |
| 8 |