Forum Discussion
Measure with filters
Hi! I have a table called DM_ACTIVITY with several columns two of which are activity_duration and activity_group. I would like to create a measure in the report mode that sums up all the activity_d...
Hi Anonymous ,
Try this measure
Total = VAR a = CALCULATE ( SUM ( 'DM_ACTIVITY'[activity_duration] ), 'DM_ACTIVITY'[activity_group] IN { "RIG", "D1C", "D2C" } ) RETURN DIVIDE ( a, 24 )or
Total = VAR a = SUMX ( FILTER ( 'DM_ACTIVITY', 'DM_ACTIVITY'[activity_group] IN { "RIG", "D1C", "D2C" } ), 'DM_ACTIVITY'[activity_duration] ) RETURN DIVIDE ( a, 24 )Regards,
Harsh Nathani
Hi Anonymous ,
Try this measure
Total =
VAR a =
CALCULATE (
SUM ( 'DM_ACTIVITY'[activity_duration] ),
'DM_ACTIVITY'[activity_group]
IN {
"RIG",
"D1C",
"D2C"
}
)
RETURN
DIVIDE (
a,
24
)
or
Total =
VAR a =
SUMX (
FILTER (
'DM_ACTIVITY',
'DM_ACTIVITY'[activity_group]
IN {
"RIG",
"D1C",
"D2C"
}
),
'DM_ACTIVITY'[activity_duration]
)
RETURN
DIVIDE (
a,
24
)
Regards,
Harsh Nathani
Hi Anonymous Thanks! I used the first one.
What if I need add another filter (value "P") from another column (activity_class) in the same table?
what's wrong with this formula?
Prod time =VAR a =CALCULATE (SUM ( 'DM_ACTIVITY'[activity_duration] ),'DM_ACTIVITY'[activity_group]IN {"RIG","D1C","D2C"}&& 'DM_ACTIVITY'[activity_class]IN {"P"})RETURNDIVIDE (a,24)HI Anonymous ,
Just a slight modification then.
Prod time = VAR a = CALCULATE ( SUM ( 'DM_ACTIVITY'[activity_duration] ), FILTER ( 'DM_ACTIVITY', 'DM_ACTIVITY'[activity_group] IN { "RIG", "D1C", "D2C" } && 'DM_ACTIVITY'[activity_class] IN { "P" } ) ) RETURN DIVIDE ( a, 24 )
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Thank you very much!