Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I need to clear the amounts whitch conjunctionally eliminate each other, like 5 and -5, also i need to respect if they are either Manzana(Apples) or Pera (Pear), and also it needs to respect this conditions: AB=CD, YU=HR, AB=YU .
The resultant columns should be:
Which are the values that didn´t conjunctionally eliminate each other.
Thanks.
@jlafran ,
Try a formula like
sumx(table, if(isblank([Neted]) ,[value], blank()))
or
sumx(values(table[group]), if(isblank([Neted]) ,[value], blank()))
or
sumx(values(table[group]), if(isblank(sum(Table[Neted])) ,Sum(Table[value]), blank()))
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Hi, @amitchandak. I´m really sorry if i wasn´t clear in my initial explanation. I edited my original post, i hope now it´s clearer. Thank you very much.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |