Doesn't count the SUM.

[Anonymous]

Hello,

I have two tables and there is a relationship between them.

Table Procotols:

Employee	Protocol type
John	A
Tim	B
John	C
John	A

Table Time:

Protocol type	Time
A	0,5
B	0,5
C	2

I have relationship between them by Protocol type.

I'm trying calculate SUM or TOTAL - it's not working or show bad value (non-summed values)..

For example, I need to see this result:

The time type is set to decimal value.

[amitchandak · Accepted solution]

@Anonymous , Try like

sumx(Procotols, related(Time[Time]))

[tex628]

In your Protocol table add the following calculated column:

Column = Related(Table Time[typeTime])

Then SUM() that column instead. 

Br,
J

[Anonymous]

Did you create a measure that uses the SUM() function? If so, can you share a screenshot of this formula?