Create a table with min value as a column

[Berl21]

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?

Thanks,

Pauline.

[tamerj1]

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

[Berl21]

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