Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sccoleman1189
Helper I
Helper I

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 and my column information is coming from my calendar table. The order count is based on a measure that I created in my order table. 

 

I also have another column that I want to add to my matrix from my order table (ok on arrival).

 

This is what my matrix looks like now:

Capture 1.PNG

This is what I am looking to accomplish:

Capture.PNG

 

Any advice would be greatly appreciated!

 

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

Hi @sccoleman1189 

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
v-cherch-msft
Employee
Employee

Hi @sccoleman1189 

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hnguy71
Memorable Member
Memorable Member

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?



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

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



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

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.



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

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 aboveCapture 2.PNG

 

Right. Make sure the measure is in the Values property on the matrix visual



Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Yup! It is. I might just try to color code te results to make it a little easier to read for the end user.

 

Capture 3.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.