topic Re: Count smaller table rows compared to big table in DAX Commands and Tips

Count smaller table rows compared to big table

Anonymous — Fri, 07 Aug 2020 08:30:46 GMT

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

Re: Count smaller table rows compared to big table

Mariusz — Fri, 07 Aug 2020 09:41:40 GMT

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

Re: Count smaller table rows compared to big table

amitchandak — Fri, 07 Aug 2020 10:19:48 GMT

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