topic Sum of Min in DAX Commands and Tips

Sum of Min

Jay20024 — Wed, 27 Nov 2024 14:52:22 GMT

Hi Folks,

Got 2 tables :

First

Second

Both Host fields are linked

So I can get this table where I need to compare Physical Cores figures with SUM vCPU figures to keep the lowest one, line by line.

PB also applies the measure comparison at the TOTAL level, I just want to apply the measure line by line and then sum the result of the comparison.

I need to calculate the correct sum (88) to also display the figure into a Smartcard.

I thank you in advance for your help on this topics.

Re: Sum of Min

FreemanZ — Wed, 27 Nov 2024 15:01:28 GMT

hi Jay20024 ,

try like:

measure =

SUMX(

VALUES(table1[host]),

MIN(

CALCULATE(SUM(table1[Physical Cores)),

CALCULATE(SUMX(RELATEDTABLE(table2), table2[vCPU])

)

Re: Sum of Min

Jihwan_Kim — Thu, 28 Nov 2024 07:16:52 GMT

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Physical Cores: = SUM(Host[Physical Cores])

vCPU: = SUM('VM and vCPU'[vCPU])

Keep Min: = SUMX ( VALUES ( Host[Host] ), MIN ( [Physical Cores:], [vCPU:] ) )

Re: Sum of Min

Jay20024 — Fri, 29 Nov 2024 13:07:55 GMT

Great ! Thank you very much Jihwan_Kim. It works like a charm and it also allow me to understand certain PB approaches. thank to you, I improve my understanding about the way PB works.

Have a nice day !

Re: Sum of Min

Jay20024 — Fri, 29 Nov 2024 13:08:27 GMT

Thank you for your answer !