Forum Discussion
msciarrino
Helper I
Helper IGetting 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! 🤠
msciarrinoHelper I
Helper IThank you so much! That worked like a charm!