Hello Support ForumDAX Cancellations measures Question.pptx (134.1 KB) :
I wanted to ask for some help on a DAX formula for "cancellations. I have attached the background for the question.
What is throwing me off is that I am using a CALCULATE statement and a TREAT AS to get to the normal required answer for cancellations before trying to filter the result by division.
Now I’m trying to get this measure to work based on a divisional split ( Div 1 & Div 2). The key to tie the measures for this purpose is a many to one relationship between OPEN ORDERS ( table where cancellations are derived from) and PRODUCTS which has the only key ( NO_) to give these two tables a relationship. The PRODUCTS table also has the field where division is available.
Any input is very much appreciated!