Solved: Calculation

Anonymous · ‎06-21-2017

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 · ‎06-21-2017

@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

Lima - Peru

View solution in original post

Vvelarde · ‎06-21-2017

@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

Lima - Peru

Anonymous · ‎06-21-2017

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

Vvelarde · ‎06-21-2017

@Anonymous

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

Lima - Peru

Anonymous · ‎06-21-2017

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

Calculation