Forum Discussion
Solved
Getting a measure to count specific items based on matrix drilldown.
Hello All, I am attempting to create a Matrix that will show how many items we need to order, and how many items we actually ordered. Everytime we order a parent tool, all the children need to be...
use this measure for
Quantity Needed Measure:
QNeed =calculate(Count('Order Table'[Child Item]),treastas( values(need_table[parent]) , order_table[parent]),treastas( values(need_table[child]) , order_table[child]))If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
use this measure for
Quantity Needed Measure:
QNeed =
calculate(
Count('Order Table'[Child Item]),
treastas( values(need_table[parent]) , order_table[parent]),
treastas( values(need_table[child]) , order_table[child])
)
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠