cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Two table measure subtract with particular category

Hi,

 

I have two table one has master data(table 10 with sum measure and another one i have few category i want to subtract table 2 values by category.

 

Two table has common value has company code but many to many sub category. I want to exclude paticular category value from one another. total level i can able to get the desired result but not on the category level. Can any one help on this. there are sub level below the category like GL and cost center for both table.

 

I have tried to apend but getting some different result and also tried to use CALCULATE function with FILTER not getting the desired output.

Table 1
Group 1Group 2ChinaNetherlandIndiaMalaysiaUnited states
Net RecoveriesNet Recoveries           6,891         36,347       79,299     85,000           8,007
Direct costSalaries & Burden         (2,544)       (17,180)     (47,930)    (38,161)         (3,050)
Direct costContractor Cost              (38)              (95)        (6,356)      (1,734)            (108)
Direct costDepreciation            (884)         (3,213)               (4)      (2,986)              (12)
Direct costTraining                 (8)              (63)             (31)           (35)                 (6)
Direct costTravel              (99)            (148)           (235)         (188)              (17)
Direct costOthers (FX & others)              480         (4,949)        (4,365)        8,780                43
Direct costProject & Cross Co              811            (824)        (3,802)      (2,078)            (523)
Overhead costFunctions Global         (1,016)         (5,644)     (16,148)    (11,576)         (2,036)
Overhead costFunctions Local            (828)         (1,622)        (8,804)      (6,601)            (438)
CommercialBillable Cost                 -         (11,151)        (2,646)             (3)         (2,548)
CommercialRevenue                 -           12,821         1,323           308           2,177
CommercialTW Cost                 -           (1,465)           (788)         (431)         (1,868)
CommercialBRNC                 -              (301)                -                -                   -  
TaxCommercial                 -                   -                  -                -                   -  
TaxTax            (691)              (60)         3,388    (14,847)                91
IG DividendIG Dividend                 -           (8,143)                -                -                   -  
 
Table 2
Group 1Group 2ChinaNetherlandIndiaMalaysiaUnited states
Direct costSalaries & Burden     2,494.07     1,058.80         58.91     142.38        525.06
Direct costContractor Cost                 -                   -                  -                -                   -  
Direct costOthers (FX & others)                 -     (1,081.79)                -                -         (307.64)
Direct costProject & Cross Co   (2,121.87)   (4,448.40)    1,225.72              -                   -  
Overhead costFunctions Global     1,095.34        123.90       (73.62)     188.58   (1,464.91)
Overhead costFunctions Local           32.44           37.81       268.67   (114.53)       (264.33)
 

Thanks,

Mani

 

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Kudoed Authors