Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric certified for FREE! Don't miss your chance! Learn more
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) and column "dt".
Is this possible within Power BI? I have tried filtering, grouping as well as allexcept without any success.
Source table:
Desired Result:
Any assitance is greatly appreciated.
Solved! Go to Solution.
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 Sheng
Hi @Anonymous,
I just wanted to say thanks for your assitnace. It was very helpful. What a great community!
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 59 | |
| 48 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 107 | |
| 104 | |
| 39 | |
| 27 | |
| 27 |