Get a min from summarise table

[marcio_fornari]

Hi Everyone,

How can i get the min value from this table created in Dax:

EVALUATE
var t = SUMMARIZE(
	F_CUSTO_FRANGO,
	F_CUSTO_FRANGO[Ano-Mes],
	"Total", sum(F_CUSTO_FRANGO[Total Final]
	)
)
return
t

I need the min of the sum, i think a a summarize table and get the min, i don't know if is better way..

[Jos_Woolley · Accepted solution]

Hi,

You could use this measure:

MinSum =
MINX (
    SUMMARIZE (
        F_CUSTO_FRANGO,
        F_CUSTO_FRANGO[Ano-Mes],
        "Total", SUM ( F_CUSTO_FRANGO[Total Final] )
    ),
    [Total]
)

Regards

[CNENFRNL · Accepted solution]

=
MINX(
    SUMMARIZECOLUMNS(
        F_CUSTO_FRANGO[Ano-Mes],
        "@Total", SUM( F_CUSTO_FRANGO[Total Final] )
    ),
    [@Total]
)

[vishal097]

Hello All,

I have the similar requirement where I want Sum of Minimum QTY in each SFC ( there are multile record at SFC level ) from Summarize Table 

I have tried Measure as 

Units Produced Within Standard Time =

VAR Result =

SUMX(

SUMMARIZE (

Fact_DailyMgmt_ThroughputTime_Detail,

Fact_DailyMgmt_ThroughputTime_Detail[SFC],

Fact_DailyMgmt_ThroughputTime_Detail[START_TIME],

Fact_DailyMgmt_ThroughputTime_Detail[END_TIME],

Fact_DailyMgmt_ThroughputTime_Detail[Wait_Time_Type],

"QTY", FIRSTNONBLANK ( Fact_DailyMgmt_ThroughputTime_Detail[QTY], 0 ),

"IsEligible",

IF (

SUM ( Fact_DailyMgmt_ThroughputTime_Detail[Throughput_Time] )

<= SUM ( Fact_DailyMgmt_ThroughputTime_Detail[ERP_Target] ),

1 , BLANK() ) ) , [QTY] * [IsEligible] )

RETURN

Result

but it is giving sum of QTY for all due to which value is not correct 

can someone please help.

[marcio_fornari]

Thank you so much everyone! 
it's to easy! OMG 😅

[Fowmy · Accepted solution]

@marcio_fornari 

To aggregate over a virtual table, you can use an iterator function: with the dame code you have, add the following:

EVALUATE
VAR t =
    SUMMARIZE (
        F_CUSTO_FRANGO,
        F_CUSTO_FRANGO[Ano-Mes],
        "Total", SUM ( F_CUSTO_FRANGO[Total Final] )
    )
RETURN
    MINX ( t, [Total] )

[CNENFRNL · Accepted solution]

=
MINX(
    SUMMARIZECOLUMNS(
        F_CUSTO_FRANGO[Ano-Mes],
        "@Total", SUM( F_CUSTO_FRANGO[Total Final] )
    ),
    [@Total]
)

[Jos_Woolley · Accepted solution]

Hi,

You could use this measure:

MinSum =
MINX (
    SUMMARIZE (
        F_CUSTO_FRANGO,
        F_CUSTO_FRANGO[Ano-Mes],
        "Total", SUM ( F_CUSTO_FRANGO[Total Final] )
    ),
    [Total]
)

Regards