Count smaller table rows compared to big table

[Anonymous]

I have 2 tables. Table 1 with 5000 variables. Table 2 with 2900 variables.

Most of my charts are built from the 5000 variables however I have a card to count the variables but keep coming up with 5000.

Is there a way only count Table 2 variables?

I've tried RELATED and COUNTROWS to no avail

[amitchandak]

@Anonymous , if there is 1-M join

then you can do a new column

Item Name = RELATED('item'[Brand]) //Item is on one side sales is on M side where column is create

// Column in sales from a city table

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])

//You can use as flag

Measure =calculate(countrows(Table1), filter(Table1,Table1[ID] in values(Table2[ID])))

Or use

https://docs.microsoft.com/en-us/dax/treatas-function

[Mariusz]

Hi @Anonymous 

Can you provide some data sample and DAX code as its not easy to understand what you are trying to achieve?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn