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. 

AmandaHore's avatar
AmandaHore
Helper I
1 year ago

Thanks Pankaj - I could not add the 2 new measures as rows, It lets me add them as values.

When I added them as values it included all the rows for all projects in the system.  Even where all 3 columns (Task hours, worked hours and remaining hours are 0.  

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello AmandaHore 

 

You can try this measure it will exclude the zero

 

TaskHoursFiltered =
IF(SUM('Table'[Task Hours]) > 0 ||
SUM('Table'[Worked Hours]) > 0 ||
SUM('Table'[Remaining Hours]) > 0,
SUM('Table'[Task Hours]))

 

Thanks,
Pankaj

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