topic Count rows of another table without relationship in DAX Commands and Tips

Count rows of another table without relationship

Anonymous — Wed, 13 Jan 2021 20:55:48 GMT

Hello,

Please, I need to make a column where I can count how many rows there are in another column of the other table, but I need that when I apply the visual filter, the number changes.

For example:

I have two tables, Table and Table Count.... Then in the Table Count I made a column and wrote the expression "CALCULATE(COUNT('Table'[ID]))". After that I created a card and in the field put the column that I have just created, as the number of the rows in the Table is 2, the number that the card shows is 2. Perfect!

The problems is because when I use the visual filter in this card using the Table, not the Table Count and select just a line, the number does not change.

Could somebody help me please?

Best regards,

Re: Count rows of another table without relationship

AlB — Wed, 13 Jan 2021 21:45:28 GMT

Hi Anonymous

You need a measure. Calc columns are static

Can you show a sample of the two tables and explain exactly what you need? Count rows how, based on what?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Count rows of another table without relationship

Anonymous — Wed, 13 Jan 2021 23:51:02 GMT

Hi @AlB,

Thank you for the answer!

I know, but the problem is that I can't use measure because one of the tables is one calendar... Let me explain to you:

I have one table where there are days from today to the next 7 days, and in each day I need to calculate how many rows I have in the another table for example:

Table A

Date Aircrafts With Problems

01/13 2

01/14 4

01/15 5

In the Column Aircrafts With Problems I use a calc column with a lot of filters.

Table B

Aircraft Type Status Date Next Status Date Last Status

C152 Open Null

C172 Close Null

So, the Table A does not have realtionship with the Table B, I created the cal column for to calculate how many aircrafts I have in that day, and I need that it works with the visual filter, because I need to filter for the Aicraft Type, because if it does not work, I will have to create a cal column for each Aircraft Type, for example:

Table A (Example)

Date C152 Aircrafts With Problems C172 Aircrafts With Problems

01/13 2

01/14 4

01/15 5

Could you understand me?

Best regards,

Re: Count rows of another table without relationship

amitchandak — Thu, 14 Jan 2021 08:11:13 GMT

Anonymous , There needs to some filter that we need to common to make sure you get a different count.

As a new column in Table A, I tried adding a date relation

C152 Aircrafts With Problems = countx(filter(TableB, table2[status] = "Open" && isblank(tableB[Date Next Status]) && tableB[Date Next Status] >TableA[Date]),table2[Aircraft Type])