topic Re: Get a min from summarise table in DAX Commands and Tips

Get a min from summarise table

marcio_fornari — Fri, 06 Aug 2021 19:09:17 GMT

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 — Fri, 06 Aug 2021 19:47:42 GMT

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 — Fri, 06 Aug 2021 20:07:45 GMT

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

Fowmy — Fri, 06 Aug 2021 20:55:50 GMT

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

marcio_fornari — Fri, 06 Aug 2021 21:10:05 GMT

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

vishal097 — Wed, 07 Sep 2022 14:13:48 GMT

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.