This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
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.
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]
)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |