Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Active relationship causing count to be wrong

I'm trying to count number of empty propertys by counting the previous tenancy numbers that exist in the empty property table. "hraptvpd" It's worth mentioning that hraptvpd is directly quering the ...
COUNT
datesbetween
DAX
Help
relationships
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    first you have to deactivate the active relationship. Or otherwise you need add REMOVEFILTERS ( DateQuery ) with CALCULATE to the following code which considers the property empty only if it is epmty in the whole period. 

     

    Count of property empty =
COUNTROWS (
    FILTER (
        hraptvpd,
        hraptvpd[prev_tency_end] < MIN ( DateQuery[Date] )
            && hraptvpd[next_tency_st] > MAX ( DateQuery[Date] )
    )
)

     

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

Hi Dan

kindly share a screenshot of the data model tab

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    tamerj1 

    Please ignore the mess. You wouldn't want to see the rest.  😛 

    1. is hraptvpd[next_tency_st] to DateQuery[Date] (this is active)

    2. is hraptvpd[prev_tency_end] to DateQuery[Date] (this is inactive)

    3. is hraptvpd[act_end_dt] to DateQuery[Date] (this is inactive)

     

     

     

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Hi Anonymous 

      first you have to deactivate the active relationship. Or otherwise you need add REMOVEFILTERS ( DateQuery ) with CALCULATE to the following code which considers the property empty only if it is epmty in the whole period. 

       

      Count of property empty =
COUNTROWS (
    FILTER (
        hraptvpd,
        hraptvpd[prev_tency_end] < MIN ( DateQuery[Date] )
            && hraptvpd[next_tency_st] > MAX ( DateQuery[Date] )
    )
)

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Even if I remove the relationships it doesn't count anything 😞