Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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] ) )
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |