topic Create a table with min value as a column in DAX Commands and Tips

Create a table with min value as a column

Berl21 — Mon, 01 May 2023 18:16:56 GMT

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.

Re: Create a table with min value as a column

tamerj1 — Mon, 01 May 2023 18:29:59 GMT

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

Re: Create a table with min value as a column

Berl21 — Mon, 01 May 2023 18:38:13 GMT

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