Forum Discussion
Cardinality between lookup table and fact table
Anonymous there are few ways to solve this, make date and a table relationship to inactive and make user lookup and a table as 1 to 1, logically that is 1 to 1 and create a measure to calculate the user by using USERELATIONSHIP in the measure, something like this:
User Count Measure = CALCULATE ( COUNTROWS ( TableA ), USERELATIONSHIP ( DateTable[Date], TableA[Created_At] ) )and in line chart use above measure.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserAnonymous there are few ways to solve this, make date and a table relationship to inactive and make user lookup and a table as 1 to 1, logically that is 1 to 1 and create a measure to calculate the user by using USERELATIONSHIP in the measure, something like this:
User Count Measure =
CALCULATE ( COUNTROWS ( TableA ), USERELATIONSHIP ( DateTable[Date], TableA[Created_At] ) )
and in line chart use above measure.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡