Forum Discussion
Simple measure prolbem
I got two tables. One Is OrderNumber (with distinct values) and second is Sales Order Items. I built a matrix with order number from OrderNumber and itemnumber from Sales Order Items. One order can h...
Hey Marcin82
Can you please share your sample dataset and expected output so that I can help you with an accurate solution.
I would like to have only relevant items under order with count of all of them.
I achieved it when I add VALUES(OrderNo) from OrderItems table as a CALCULATE argument . But why I get such a mess without it? There is a filter in the context from OrderNumber (but from other table). It should still be kept. Measure only removes filter on items.
