Forum Discussion
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 ...
You may try to use ISFILTERED function.Here is the similar post for your reference.
Ok on = IF ( ISFILTERED ( Calendar[Date] ), [Measure], [OK on Arrival] )
Regards,
Still a little confused. Convert what to a measure?
Ok on arrival is a measure. Convert the conditional column to a measure?
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.
Ahh. Ok. I understand.
That works, but doing that gets this result. I just want the count to be at the end of the table like pictured above
Right. Make sure the measure is in the Values property on the matrix visual
Yup! It is. I might just try to color code te results to make it a little easier to read for the end user.