Forum Discussion
dax help
Well, you have to decide what you want to do. I can't tell you, it's your business after all :)
You could sum up all the values in the corresponding rows or you could take the min/max... you could do many things but it's you who has to decide. You could also return BLANK if there is more than 1 corresponding row. It's your call, mate :)
Best
Darek
The code
-- This code will return an error if
-- there is more than 1 row in T1
-- for any of the roles. But according
-- to the conditions there should be
-- only unique roles in T1.
[Total Mission Hours] = -- calculated column
var __role = T2[Labor Class Name]
var __totalMissionHours =
CALCULATE (
VALUES ( T1[Total Mission Hours By Region Name] ),
T1[Role] = __role
)
return
__totalMissionHours
Best
D.
Hi,
Thanks for replying!
I gave an overview of what I am trying to achieve. there is more than 1 row in T1.
What can be done if this is the scenario?
Thanks,
Well, you have to decide what you want to do. I can't tell you, it's your business after all :)
You could sum up all the values in the corresponding rows or you could take the min/max... you could do many things but it's you who has to decide. You could also return BLANK if there is more than 1 corresponding row. It's your call, mate :)
Best
Darek