Counting Rows in a Table Visual

[bernate]

Hello, I have the visual below. Each column is marked by which table it comes from. Column A is "Location," Column B is "Region," and columns C are "Item Number", "Count of % Category," and "% Category."

As you can see, the total is coming to 8 but I want it to be 13 as I have 13 values in column A that are not blank. 

Here are how the tables are connected. Table C has unique item numbers and is connected to tables B and C on the "Item Number" column. Tables A and B are connected on the "Location" column.

[aleksvp]

There is a solution for that using Python Visual. It is a solution that fits even if you use field parameters in your table.
https://www.simpledev.tech/post/how-to-display-the-number-of-rows-in-a-power-bi-table-visual

[bernate · Accepted solution]

Hi everyone, I solved this issue by doing a simple COUNTX([Table A], 'Location'). This measure gave me a column with the correct total of 13. I don't think I explained what I wanted clearly enough but I'm glad to have found a solution that worked for me!

[PhilipTreacy]

@bernate 

Please provide anonymised data that we can use rather than have to recreate everything from scratch.

Regards

Phil