Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |