Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count smaller table rows compared to big table

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...
COUNT
COUNTROWS
related
tables
union
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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