Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
This is what I am looking to accomplish:
Any advice would be greatly appreciated!
Solved! Go to Solution.
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 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?
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |