Forum Discussion
Calculating Differences
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 MRadaci,
It will be help if you share sample data/pbix file for test.
In addition, if you mean create dynamic column/table from slicer/filter, current power bi not support this, please use measure to instead.
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
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 ShengHi Anonymous,
I just wanted to say thanks for your assitnace. It was very helpful. What a great community!