Forum Discussion
Solved
Calculating Differences
Hello, Pardon my ignorance, but I am in need of some direction/assiatnce. I have a table that I need to calculate the difference of the daily_%_total by column "dialer" (has 2 values, N and U) a...
Hi MRadaci,
You can try to use below formula to show diff on total level.
Diff = IF ( ISFILTERED ( Sheet1[system] ), SUM ( Sheet1[daily_%_total] ), CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "N" ) - CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "U" ) )Regards,
Xiaoxin Sheng
Hi Xiaoxin!
Thanks for your response. I have attached a sample dataset (xls).
The goal is for a sliced date, compare difference in systems (N vs. U) for each category's %.
Thanks for any assitance you can provide.
https://github.com/AFC1886/SampleData/blob/master/Example%20Data.xlsx
Hi MRadaci,
You can try to use below formula to show diff on total level.
Diff =
IF (
ISFILTERED ( Sheet1[system] ),
SUM ( Sheet1[daily_%_total] ),
CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "N" )
- CALCULATE ( SUM ( Sheet1[daily_%_total] ), Sheet1[system] = "U" )
)
Regards,
Xiaoxin Sheng
Hi Anonymous,
I just wanted to say thanks for your assitnace. It was very helpful. What a great community!