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,
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?
- 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!
Convert that to a measure and add that into the Values field of a matrix visual
Still a little confused. Convert what to a measure?
Ok on arrival is a measure. Convert the conditional column to a measure?
