Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have data kind of similar to this excel file in the PQ, I would like to get the difference of value column between sent and reci(att column) for each unique event ID
I was able to get that where for a the measure would be 10 and for b it would be 15 and for c 0 but the total is not adding up as it should be 25
I am trying to calculate it like this
Can some one help me with this,please?
Solved! Go to Solution.
Hi @Varez42
please try
=
SUMX ( 'Table', IF ( 'Table'[att] = "reci", - 'Table'[Value], 'Table'[Value] ) )
Hi @Varez42
please try
=
SUMX ( 'Table', IF ( 'Table'[att] = "reci", - 'Table'[Value], 'Table'[Value] ) )
HI @KeyurPatel14
thanks for the response,
So based on the above data , I am trying something like this but as you can see the total should be 50 but it is not .
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |