Calculation

[Anonymous]

Hi,

I am new to Power BI and would like to get some assistance.

I have a table like this and would like to create a measure to be 13 (=3+8+2).

Could anyone tell me how I can do it?  Thanks in advance.

[Vvelarde · Accepted solution]

@Anonymous

Hi, create a measure with this code

SumDeptCount =
SUMX (
    SUMMARIZECOLUMNS (
        Table2[Service Department],
        "DeptC", AVERAGE ( Table2[DeptCount] )
    ),
    [DeptC]
)

Let me know if works

Victor

Lima - Peru

[Anonymous]

Thanks, however, it's not working.........

[Vvelarde]

@Anonymous

hI, Can you explain more why it's not working,

[Anonymous]

Thanks. I guess something is not working well on my power BI.  I simply closed and opened it up again and it works.