Goals without average

[Till]

Hallo Community,
i have a question about a goal calculation.
I have two Excel tables. One with a AHT (average handling Time and name of a topic) and the other table with goals for the AHT an the topic. (Topic 1 and Topic 2).
I join the tabels like the picture.
The aht measure is sum(aht[cht])/sum(aht[anzahl])

 now i take a matrix and set the fields aht und goals

Now I have the problem that I can only calculate an average value for the goals.

 

What am i doing wrong?

Thanks for help.
Till

[v-chuncz-msft · Accepted solution]

@Till,

Based on the above, you may set cross filter direction to 'Both' in the Edit relationship dialog.

[Till]

Thanks, an sorry for the late request.

It works