Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix - Not Showing All Columns

Hello, I have a new Matrix table that I created.   I've selected two columns to use in this table.   Only one column displays on this table.    There are arrows at the bottom of the matrix table that...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI,@creynolds

        You may try to use these two formula like below:

    Not Started = IF( 'Production Data'[Date]>=TODAY(),1,0)

Started = IF('Production Data'[Date]<TODAY(),1,0)

    Result:

    Basic data

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I was able to correct the issue by creating two independent "New Measures".   However my new problem -- both new measurements return the exact same result:

 

Started = 'Production Data'[JOB_ORIG_START] < TODAY() 

Not Started = 'Production Data'[JOB_ORIG_START] > TODAY() 

 

The result for both is returning a count of the # of occurrences.    There should be no reason both columns return the exact same #.

 

                      Not Started           Started

MidWest             36                       36

Southeast             2                         2

West                   25                        25

 

Any ideas?

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI,@creynolds

    You may try to use these two formula like below:

Not Started = IF( 'Production Data'[Date]>=TODAY(),1,0)

Started = IF('Production Data'[Date]<TODAY(),1,0)

Result:

Basic data

 

Best Regards,

Lin