Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |