column countrows from Related Table

[cosminc]

Hi all,

please can you help me with the right syntax?

2 tables: table 1 and table2

for table 2 i need to countrows from table 1 - related table but i need also to include 2 adjust table 1 with 2 filters columnA = 1 && column B = 1

something like this:

CALCULATE(COUNTROWS(RELATEDTABLE(table1)), FILTER(table1, columnA = 1 && column B = 1))

Thanks,

Cosmin

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[d_gosbell]

Assuming that you are using this expression in a calculated column you might be able to do something like the following

CALCULATE(COUNTROWS( FILTER( RELATEDTABLE(table1), table1[columnA] = 1 && table1[column B] = 1))