cancel
Showing results 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

Helper I

Remove Post

Removing question.

11 REPLIES 11
Helper I

Removing post.

Super User

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

Helper I

Removing post.

Super User

HI, @dochtang

try below code

``````MIN GUNBARREL X = CALCULATE(
MIN('All Wellbores'[Gunbarrel X]),
removefilters('All Wellbores'[shortname])

)``````

Super User

hello @dochtang , why not tru using minx?

``````MIN GUNBARREL X = MINX(ALL('All Wellbores'), 'All Wellbores'[Gunbarrel X])
``````
Helper I

Removing post

Super User

i see i used

``ALL('All Wellbores')``

try using only

``````'All Wellbores'
so
MIN GUNBARREL X = MINX('All Wellbores', 'All Wellbores'[Gunbarrel X])
``````

Helper I

Removing

Super User

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

Helper I

Removing

Super User
``````MIN GUNBARREL X =
VAR SelectedIDs = VALUES('YourSlicerTableName'[shortname])
RETURN
MINX(
FILTER('All Wellbores', 'All Wellbores'[shortname] IN SelectedIDs),
'All Wellbores'[Gunbarrel X]
)
``````

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

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

Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors