Forum Discussion

AmandaHore's avatar
AmandaHore
Helper I
1 year ago
Solved

Help with values in a Matrix

 Hi I need help with getting all the values shown in a Matrix The matrix is a list of projects and project tasks for a person.  It shows the hours they were allocated on the project (Task Hours), t...
Need Help
  • AmandaHore's avatar
    AmandaHore
    1 year ago

    This has not resolved the issue - as I needed to do a filter within that.  I have gone down a different path to address as this was getting a bit too complicated for my experience and what we were trying to achieve. 

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello AmandaHore 

 

You try this

Remaining Hours =
VAR TaskHours = SUM('Table'[Task Hours])
VAR WorkedHours = SUM('Table'[Worked Hours])
RETURN IF(ISBLANK(WorkedHours), 0, TaskHours - WorkedHours)

 

 

Worked Hours Adjusted =
IF( ISBLANK( SUM('Table'[Worked Hours]) ), 0, SUM('Table'[Worked Hours]) )

Task Hours Adjusted =
IF( ISBLANK( SUM('Table'[Task Hours]) ), 0, SUM('Table'[Task Hours]) )

 

 

 

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos, it would be greatly appreciated.