Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Need your expertise, please. If i have this set of activity, how will i come up with a measure that will
1.show total of all activity except "rest" for example
2. total of "rest hrs"
Activity | Hours |
Running | 1 |
Swimming | 2 |
Jumping | 3 |
Rest | 2 |
Dancing | 6 |
TIA
Solved! Go to Solution.
please disregard my initial reply... here's what i've got after following what was instructed
1) Sum of hours = SUM(Table[Hours]) - OKAY
2) Sum of rest hours = CALCULATE([Sum of Hours], Table [Activity] = "Rest") - OKAY
3) Sum of all excep "Rest" =
CALCUALATE([Sum of hours], ALL(Table[activity])) - [Sum of rest hours] -
With the following measures:
1) Sum of hours = SUM(Table[Hours])
2) Sum of rest hours = CALCULATE([Sum of Hours], Table [Activity] = "Rest")
3) Sum of all excep "Rest" =
CALCUALATE([Sum of hours], ALL(Table[activity])) - [Sum of rest hours]
Proud to be a Super User!
Paul on Linkedin.
please disregard my initial reply... here's what i've got after following what was instructed
1) Sum of hours = SUM(Table[Hours]) - OKAY
2) Sum of rest hours = CALCULATE([Sum of Hours], Table [Activity] = "Rest") - OKAY
3) Sum of all excep "Rest" =
CALCUALATE([Sum of hours], ALL(Table[activity])) - [Sum of rest hours] -
Appreciate your quick revert @PaulDBrown
here's what i got
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |