Forum Discussion

gracizach's avatar
gracizach
New Member
4 years ago
Solved

How to group with calcs

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 Te...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

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

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

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