measure to count

[Anonymous]

Hello,
There are three tables linked together in the model as follows:

Table1
--------
Key
EntityID

Table2
--------
EntityID

Table3
---------
TypeName
EntityID

At present, there is an active relationship between table1 and Table2 on EntityID
Table2 (1) --> (*) Table1 as 1 to many - single direction from Table2 to Table1
Table2(1) --> (*) Table3 as 1 to many - single direction from Table2 to Table3

What is the measure to show the count of rows in Key column for each of the TypeName
Example:

TypeName        Count
---------------------
A                       15
XMT                  12
...

Thnak you

[Stachu · Accepted solution]

you can use TREATAS for that
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

something like this

Measure =
CALCULATE (
    COUNTROWS ( 'Table1' ),
    TREATAS ( VALUES ( 'Table2'[EntityID] ), 'Table1'[EntityID] )
)

[Anonymous]

Thank you

---

@Stachu wrote:

you can use TREATAS for that
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

something like this

Measure =
CALCULATE (
    COUNTROWS ( 'Table1' ),
    TREATAS ( VALUES ( 'Table2'[EntityID] ), 'Table1'[EntityID] )
)

---

Thank you