how to calculate

[HUAM]

Hi, all

When the IDs are the same, I want to get True if the sum of total is 1.

[truptis]

Hi @HUAM , Follow the below steps:

Step 1:

Create a new column which says Count_Enteries. 

Count_Entries = Calculate(Count([itemIv2_lastlinkconsumerID]), filter(tablename, itemIv2_lastlinkconsumerID = EARLIER(itemIv2_lastlinkconsumerID)))
Step 2:
Result = If(Count( Count_Entries)>1 && total=1 , "TRUE", "FALSE")

@HUAM -> If this helps you, then please mark it as a solution and hit the thumbs up! Thanks.

Regards,

TruptiS

[Samarth_18 · Accepted solution]

Hi @HUAM ,

Try this:-

1EA = 
var result = calculate(sum(table[total]),filter(all(table),table[itemlv2_lastlinkconsumerid] = earlier(table[itemlv2_lastlinkconsumerid])))
return if(result = 1,True(),false())

Thanks,

Samarth