Forum Discussion

sccoleman1189's avatar
sccoleman1189
Icon for Helper I rankHelper I
7 years ago
Solved

Adding multiple columns to matrix table

I am using a matrix table to create a table that shows the number of jobs completed by day. I am using two seperate tables to compose this data.    My row information is coming from my order table ...
Need Help
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

Hi sccoleman1189 

 

You'll have to add a measure to the end of our matrix visual to accomplish that. What is your logic for what can be Okay on Arrival?

  • sccoleman1189's avatar
    sccoleman1189
    Icon for Helper I rankHelper I
    7 years ago
    OK on Arrival = CALCULATE(COUNT('FSA Order Info'[OK on Arrival v1]),'FSA Order Info'[OK on Arrival v1]="1")
     
    Ok on Arrival v1 is a conditional column that I created based on specific specifications.
     
    Thanks!
    • hnguy71's avatar
      hnguy71
      Icon for Super User rankSuper User
      7 years ago

      Convert that to a measure and add that into the Values field of a matrix visual

      • sccoleman1189's avatar
        sccoleman1189
        Icon for Helper I rankHelper I
        7 years ago

        Still a little confused. Convert what to a measure? 

         

        Ok on arrival is a measure. Convert the conditional column to a measure?