Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
i'm trying to figure out how to subtract the two values in the column "count" from each other.
This is a filtered table so I cant pivot it etc.
hoping there is some code that will put each value in a variable and then I can subtract them after.
any advise would be greatly appreciated.
Solved! Go to Solution.
You can write a measure to calculate each amount then subtract the measures.
Total Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Grand Total" )
Manual Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Manual" )
Difference = [Total Count] - [Manual Count]
Thank you so much for your help - this was slowly draining the life from me 🙂
You can write a measure to calculate each amount then subtract the measures.
Total Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Grand Total" )
Manual Count = CALCULATE ( SUM ( 'YourTable'[Count] ), 'YourTable'[Metric] = "Manual" )
Difference = [Total Count] - [Manual Count]
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |