Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
GeroVadim
Frequent Visitor

Min value of selected Field parameter measures

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:

GeroVadim_0-1661864252570.png

Mes1 = 10, Mes2 = 20, Mes3 = 30.
And i need measure with this behavior:

GeroVadim_1-1661864423275.png

GeroVadim_2-1661864450578.png

 

 

1 ACCEPTED SOLUTION
GeroVadim
Frequent Visitor

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

 

View solution in original post

3 REPLIES 3
GeroVadim
Frequent Visitor

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

 

Anonymous
Not applicable

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.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors