Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, all
When the IDs are the same, I want to get True if the sum of total is 1.
Solved! Go to 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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |