Forum Discussion

Helper III

3 years ago

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...

"DAX"

SUM of MIN

tamerj1

Community Champion

3 years ago

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

Helper III

3 years ago

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

Forum Discussion

Create a table with min value as a column

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create columns group

Creating custom columns keeps returning a structured Table column