topic Re: Sum per category in another table in DAX Commands and Tips

Sum per category in another table

JC2022 — Tue, 29 Nov 2022 14:45:26 GMT

Hi,

How do I create a measure where I calculate the TT_HRS[TT_Hours] per TT_ACT[Category]?

FreemanZ — Tue, 29 Nov 2022 15:09:09 GMT

Do you have more info about the relationship between TT_HRS and TT_ACT? What are the two linked columns?

JC2022 — Tue, 29 Nov 2022 15:12:15 GMT

The link is:

TT_ACT[Activity ID] one-to-many TT_HRS[TT_ACT_ID]

FreemanZ — Tue, 29 Nov 2022 15:39:32 GMT

try to create a measure with this:

Measure =

CALCULATE(

SUM(TT_HRS[TT_Hours]),

USERELATIONSHIP(

TT_ACT[Activity ID],

TT_HRS[TT_ACT_ID]

)

you would need to plot a Visual with TT_ACT[Category].

JC2022 — Tue, 29 Nov 2022 16:10:46 GMT

It's not working. I only get a calculated sum for one category. I would expect to get a calculated sum for each category.