Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

power bi visual - can I select rows by min (value) for a variable in a group

‎03-29-2021 02:22 AM
Hi

I'm new in powerbi. My question is: Can I select (filter) rows in powerbi visual, by min(value) from a variable in a group? For example I have a dataset:

 

row_idgroup_1vargroup_2
1A1.1X
2A1.2Y
3A0.9Z
4B0.5X
5B0.7Z
6C1X
7D2X
 
 For my visual I want to use rows: row_id =3,ow_id =4,ow_id =6, ow_id =7,

In R language I can do it with

dataset<-dataset %>%group_by(group_1)%>%dplyr::slice(which.min(var))
Is possible use   this concept  in powerbi visual?
 
Thanks
Labels:
Message 1 of 26
1,203 Views
0
25 REPLIES 25
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:27 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 26 of 26
1,024 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:24 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 25 of 26
1,025 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:20 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 24 of 26
1,025 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:17 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 23 of 26
1,026 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:14 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 22 of 26
1,026 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:11 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 21 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:07 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 20 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:04 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 19 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:01 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 18 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:58 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 17 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:54 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 16 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:52 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 15 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:49 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 14 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:46 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 13 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:43 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 12 of 26
1,027 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:40 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 11 of 26
1,028 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:37 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 10 of 26
1,030 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:35 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 9 of 26
1,033 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:32 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 8 of 26
1,034 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:29 AM

Hello, @pedrof

Depending on your description, I created data to reproduce your scenario. The pbix file is attached at the end.

mesa:

c1.png

You can create a measure as follows.

Visual Control = 
var _min = 
CALCULATE(
    MIN('Table'[var]),
    ALLEXCEPT('Table','Table'[group_1])
)
return
IF(
    SUM('Table'[var])=_min,
    1,0
)

You must then place the measure in the visual level filter to filter the result.

c2.png

Best regards

Allan

If this post helps, consider ACCEPT as the solution to help other members find it faster.

power bi visual - can I select rows by min (value) for a variable in a group.pbix
Message 7 of 26
1,034 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.

View All