topic Re: Remove Post in DAX Commands and Tips

Remove Post

dochtang — Thu, 02 Nov 2023 14:02:39 GMT

Removing question.

Re: Remove Post

eliasayyy — Fri, 27 Oct 2023 13:46:10 GMT

hello dochtang , why not tru using minx?

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

Re: Remove Post

dochtang — Thu, 02 Nov 2023 14:02:25 GMT

Removing post

Re: Remove Post

eliasayyy — Fri, 27 Oct 2023 13:54:31 GMT

i see i used

ALL('All Wellbores')

try using only

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

Re: Remove Post

dochtang — Thu, 02 Nov 2023 14:03:02 GMT

Removing

Re: Remove Post

eliasayyy — Fri, 27 Oct 2023 14:01:45 GMT

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

Re: Remove Post

dochtang — Thu, 02 Nov 2023 14:03:17 GMT

Removing

Re: Remove Post

Dangar332 — Fri, 27 Oct 2023 14:06:20 GMT

HI, dochtang

try below code

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

Re: Remove Post

eliasayyy — Fri, 27 Oct 2023 14:06:45 GMT

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

Re: Remove Post

dochtang — Thu, 02 Nov 2023 14:03:38 GMT

Removing post.

Re: Remove Post

Dangar332 — Fri, 27 Oct 2023 14:48:34 GMT

Hi, dochtang

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

MIN GUNBARREL X = minx( allselected('All Wellbores'), 'All Wellbores'[Gunbarrel X] )

Re: Remove Post

dochtang — Thu, 02 Nov 2023 14:03:54 GMT

Removing post.