Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |