Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I need to create a calculated column in the Cat table (data model below) for filtering purposes. I want to see the total count of Period ID for each Cat ID. Both fields are highlighted in yellow. I do not want to use USERELATIONSHIP. PBIX File Link
Thank you for taking the time to read!
Solved! Go to Solution.
Column = CALCULATE(DISTINCTCOUNT(Period[Period ID]),TREATAS({[Group ID]},Period[Group ID]))
What made you use the bidirectional relationship? I would change the data model to
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |