Measure triggering a full outer join

Hey Greg_Deckler

The [#m_OrderOTIF] calculated measure is returning a value for each row based on the filter context of the pivot table.  In this case your filter context is being driven from the all the non-measure columns in the grid wuch as  order_nbr, line_nbr, request_date etc.

The code in your measure appears to always returns a value for each execution of the measure and as if you had hardcoded the measure to return a fixed value such as this.  Setting the "show items with no data" on each of the non-measure columns would produce the same number of rows which would equal the total number of permutations of the distinct values from the non-meaure (implicit AND explicit measures).

#m_OrderOTIF = 1

In this case, your measure will be (logically) executed for every permutation of non-measure column values.  If it returns a non-blank value, it will create a row.

If you want fewer rows, you need to remove non-measure columns or write your DAX so in some circumstances it returns a BLANK().