JC2022Helper III3 years agoSolvedSum per category in another tableHi,How do I create a measure where I calculate the TT_HRS[TT_Hours] per TT_ACT[Category]? JC2022 to FreemanZ3 years agoFreemanZ It's not working. I only get a calculated sum for one category. I would expect to get a calculated sum for each category.
JC2022 to FreemanZ3 years agoFreemanZ It's not working. I only get a calculated sum for one category. I would expect to get a calculated sum for each category.
JC2022 to FreemanZ3 years agoFreemanZ It's not working. I only get a calculated sum for one category. I would expect to get a calculated sum for each category.
4 RepliesReplies sorted by Most LikedFreemanZSuper User3 years agoDo you have more info about the relationship between TT_HRS and TT_ACT? What are the two linked columns?JC2022Helper III to FreemanZ3 years agoThe link is:TT_ACT[Activity ID] one-to-many TT_HRS[TT_ACT_ID]FreemanZSuper User to JC20223 years agotry 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].Show More
FreemanZSuper User3 years agoDo you have more info about the relationship between TT_HRS and TT_ACT? What are the two linked columns?
FreemanZSuper User to JC20223 years agotry 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].
Related contentReplace category with Category from another tablePower Query LookUp in another tableHow to add another column from another table?[PowerQuery] add (same) column from another tablemerge or update/insert lakehouse table from another lakehouse table
