Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @v-shex-msft,
I just wanted to say thanks for your assitnace. It was very helpful. What a great community!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |