Forum Discussion

sccoleman1189's avatar
sccoleman1189
Helper 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
Super 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
Helper 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
    Super User
    7 years ago

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

    • sccoleman1189's avatar
      sccoleman1189
      Helper 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?

       

      • hnguy71's avatar
        hnguy71
        Super User
        7 years ago

        Yeah. So it would be something like this:

         

        OK on Arrival = CALCULATE(COUNTROWS([OK on Arrival v1]), [OK on Arrival v1] = "1")

        Also, I'm assuming that your calculated column is a Text Data Type since you're putting the number 1 in quotation marks.