Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculate two fields based on a filter from the dashboard

Trying to wrap my head around this one... it seems so easy when you look at the tables, but trying to get it to work in PowerBI is driving me crazy.  Hopefully, someone can help me out, :)   I have...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    If the "work table" is your master one, I think you can create a column using lookup to get the values from other tables, and then a simple sum of this column can work with any filter (with relashionship)

     

    Expected Hours = LOOKUPVALUE(TeamTable[TtlMembers];'Team Table'[Team];[Team]) 
		* LOOKUPVALUE(StartWeek[Workdays];StartWeek[Startofweek];[Startofweek])
		* LOOKUPVALUE(StartWeek[ExpectedWorkHrs];StartWeek[Startofweek];[Startofweek])

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

If the "work table" is your master one, I think you can create a column using lookup to get the values from other tables, and then a simple sum of this column can work with any filter (with relashionship)

 

Expected Hours = LOOKUPVALUE(TeamTable[TtlMembers];'Team Table'[Team];[Team]) 
		* LOOKUPVALUE(StartWeek[Workdays];StartWeek[Startofweek];[Startofweek])
		* LOOKUPVALUE(StartWeek[ExpectedWorkHrs];StartWeek[Startofweek];[Startofweek])