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 5000.

 

Is there a way only count Table 2 variables?

 

I've tried RELATED and COUNTROWS to no avail

COUNT
COUNTROWS
related
tables
union

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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

     

  • amitchandak's avatar
    amitchandak
    Super 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