Forum Discussion

muturuf's avatar
muturuf
Frequent Visitor
1 year ago
Solved

How to Count on an Inactive Relationship without using Userelationship

Hi All   I have a very simple problem that got me scracthing my head.   I have two tables one filtering the other 1 to * on an inactive relationship is there way to count the related r...
Need Help
Tips and Tricks
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    Hi muturuf 

    Generally, the best way to implement "virtual relationships" is with TREATAS.

    See this article:

    https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

     

    In this case, it would look like:

    CALCULATE (
    COUNTROWS ( 'Employee' ),
    TREATAS (
        VALUES ( 'Project'[ProjectId] ),
        'Employee'[ProjectId]
    )
)

     

    Out of interest, why do you want to avoid USERELATIONSHIP in this case?

OwenAuger's avatar
OwenAuger
Super User
1 year ago

Hi muturuf 

Generally, the best way to implement "virtual relationships" is with TREATAS.

See this article:

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

 

In this case, it would look like:

CALCULATE (
    COUNTROWS ( 'Employee' ),
    TREATAS (
        VALUES ( 'Project'[ProjectId] ),
        'Employee'[ProjectId]
    )
)

 

Out of interest, why do you want to avoid USERELATIONSHIP in this case?