Sum of Min

[Jay20024]

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.

W.

[Jihwan_Kim · Accepted solution]

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

[Jay20024]

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 !

[FreemanZ]

hi @Jay20024 ,

try like:

measure =

SUMX(

  VALUES(table1[host]),

  MIN(

    CALCULATE(SUM(table1[Physical Cores)),

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

)

[Jay20024]

Thank you for your answer !