Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MRadaci
Regular Visitor

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) and column "dt". 

 

Is this possible within Power BI? I have tried filtering, grouping as well as allexcept without any success.

 

Source table:

Table.PNG

 

 

 

 

 

 

 

 

Desired Result:

Desired Result.png

 

 

 

 

 

 

 

 

 

Any assitance is greatly appreciated. 

1 ACCEPTED 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" )
)

6.PNG

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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 %.

 Desired Result.png

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" )
)

6.PNG

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft

 

I just wanted to say thanks for your assitnace. It was very helpful. What a great community!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.