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. 

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi AmandaHore,
Can you please try below DAX

Task Hours Display =

IF(

        SUM('Table'[Task Hours]) > 0,

    SUM('Table'[Task Hours]),

    0

)

 

Worked Hours Display =

IF(

    SUM('Table'[Hours Worked]) > 0,

    SUM('Table'[Hours Worked]),

    0

)

 

remaining hours display = [Task Hours Display] - [Worked Hours Display]

 

I tried reproducing the scenario, and below is the screenshot of the output for the above DAX queries. Please verify if it works for you as well. If not, kindly provide me with a sample of your data so that I can provide a solution.

 


Thanks.