Count number of rows after a filter(s) is applied

[Roseventura]

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:

[Greg_Deckler]

Did you forget to post an image or something?

[Roseventura]

Do you not see the image?

I will post again here:

[v-danhe-msft]

Hi @Roseventura,

Your measure could work on my side, could you please offer a sample data to have a test if possible?

Regards,

Daniel He

[Roseventura · Accepted solution]

I figured out what's causing this.  If I look at the raw data, it shows that I actually have 5 lines for this Customer and Part.  What I was missing is what makes each of those 5 lines unique - the serial number.  When I add in the serial number to the table, I can see all 5 lines lines.  5 is acutally the correct number of lines.