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! Request now
Hi,
Suppose i have 3 measures: mes1, mes2, mes3.
Using Field Parameters i create slicer with an opportunity to select a measure to display.
How to calculate min value of selected measures in additional measure?
Example:
Mes1 = 10, Mes2 = 20, Mes3 = 30.
And i need measure with this behavior:
Solved! Go to Solution.
I have find only one solution, but not dinamic (you need manually update it after "Field Parameter" changed):
MINX(
FILTER (
{
( NAMEOF ( 'Measures'[mes1] ), [mes1] ),
( NAMEOF ( 'Measures'[mes2] ), [mes2] ),
( NAMEOF ( 'Measures'[mes3] ), [mes3] ),
},
[value1] IN ALLSELECTED ( MyMes[Parameter Fields] )
),
[value2]
)
I have find only one solution, but not dinamic (you need manually update it after "Field Parameter" changed):
MINX(
FILTER (
{
( NAMEOF ( 'Measures'[mes1] ), [mes1] ),
( NAMEOF ( 'Measures'[mes2] ), [mes2] ),
( NAMEOF ( 'Measures'[mes3] ), [mes3] ),
},
[value1] IN ALLSELECTED ( MyMes[Parameter Fields] )
),
[value2]
)
Hi,
I think this related thread could help: https://community.powerbi.com/t5/Desktop/Calculating-Min-Max-date-columns-based-on-selected-values/m...
If not, please reach out and i will try to help.
Thanks for your interest, but that's not it.
I need min value of selected measures, not values. I'll update topic with examples in few minutes.
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.