How to group with calcs

[gracizach]

I have the data:

Date	In	Out	Department
01/01/2021	1.500,00		Tech
01/01/2021	1.688,00		Strategy
01/01/2021		-                1.200,00	Tech
04/01/2021	780,00		Tech
05/01/2021	290,00		Strategy
06/01/2021		-                7.020,00	Innovation
07/01/2021		-              18.500,00	Global
07/07/2021		-              21.700,00	Global

The normal result in Power BI is:

Department	In	Out
Global	-	-         40.200,00
Innovation	-	-            7.020,00
Strategy	1.978,00
Tech	2.280,00	-            1.200,00

But i need other view too:

Department	In	Out
Innovation + 1/3 Global	-	-         20.420,00
Strategy + 1/3 Global	1.978,00	-         13.400,00
Tech + 1/3 Global	2.280,00	-         14.600,00

How to aggregate this way?

Thx in advance!

[Fowmy · Accepted solution]

@gracizach 

Create two measures:

In Total = 

VAR __GLOBAL = 
    CALCULATE(
        SUM(Table7[In]),
        Table7[Department] = "Global"
    )    
VAR _TOTAL = SUM(Table7[In])
RETURN
IF(
    MAX(Table7[Department] ) = "Global",
    BLANK(),
    IF(
            HASONEVALUE(Table7[Department]),
            _TOTAL + DIVIDE( __GLOBAL , 3 )
        ,
            _TOTAL
    )
)

Out Total = 
VAR __GLOBAL = 
    CALCULATE(
        SUM(Table7[Out]),
        Table7[Department] = "Global"
    )    
VAR _TOTAL = SUM(Table7[Out])
RETURN
IF(
    MAX(Table7[Department] ) = "Global",
    BLANK(),
    IF(
            HASONEVALUE(Table7[Department]),
            _TOTAL + DIVIDE( __GLOBAL , 3 )
        ,
            _TOTAL
    )
)