This seems almost so easy I’m embarrassed to post this question. That being said:
I have a table showing Customer Name, Item Number, Sales Order, Sales Order Number and Qty. I’m trying to create a measure that will calculate the total number of lines based on the filtered table. I have two filter visuals that allow the user to filter by customer and/or Item Number, but the Total Number of Sales Lines is always incorrect.
In this example, I’m expecting the Total Sales Lines to = 3, not 5.
What am I missing? The measure is shown at the top: