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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Berl21
Helper III
Helper III

Create a table with min value as a column

Hi,

 

I am still new at DAX and stumbling on this issue:

I need to create a table that shows the minimum value of a row per ID. The row value itself comes from a SQL.

This is what I wrote. In the column MININDEX for the given example, I should get a 1 everywhere. How do I correct the summarize command?

Berl21_0-1682964945173.png

Thanks,

Pauline.

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Berl21 

Please try

Table Test Summarize =
SUMMARIZE (
'Partition_Rank_SQL',
'Partition_Rank_SQL'[DimOpportunityId],
'Partition_Rank_SQL'[ID_Row],
"MININDEX",
CALCULATE (
MIN ( 'Partition_Rank_SQL'[ID_Row] ),
ALL ( 'Partition_Rank_SQL'[ID_Row] )
)
)

Hi @tamerj1 I just replaced ALL by ALLSELECTED and it worked! Thanks a million 🙂 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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