Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm creating a table report pulling odata from project online. The table has three columns, Location, resident hours and total hours. The resident hours and total hours columns are the same data but I need to filter the resident column to return all the hours related to residents and have the total hours return all hours as you would expect. i'm not sure where to start.
I'm hoping someone will point me in the right direction.
Solved! Go to Solution.
ResidentTime=Calculate(Sum(Table[hours]),Filter(Table;Table[Role]="resident")
@krpeck I might not understand what you are asking, but I would suggest either providing a sample data set with expected outcome... or What you describe is handled automatically by Power BI.
If you have a table with your resident and hours then the hours are broken out by resident.
If you just dump your total hours by itself in a visual, then it will aggregate and show all hours, or all hours of the residents you pick (if you have residents in a slicer)...
Sorry I wasn't clear, thank you for your reply. The table for this report has three columns with data like this
Location Role hours
icu Nurse 12.7
icu resident 6.1
burn resident 10.2
peds counsler 5.0
Phych resident 4.1
burn therapist 5.4
peds resident 2.0
From this data I need this report
Location Resident Time Total Time
icu 6.1 18.8
burn 10.2 15.6
Phych 4.1 4.1
peds 2.0 7.0
Since the resident time and the total time come from the same column from the same table, how do I apply a filter to just the one resident column?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |