If anyone can help I'd be enternally grateful.
Solved! Go to Solution.
Hi @Dan492813
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] )
)
)
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)
Hi @Dan492813
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] )
)
)
Even if I remove the relationships it doesn't count anything 😞
Month-Year in the DateQuery table. I have tried with a blank table and it doesn't show anything
I thought you want to slice by this column. I don't understand the meaning of using a blank table. However, please try the follow which I guess should work even in a card visual.
Count of property empty =
SUMX (
VALUES ( DateQuery[Month-Year] ),
CALCULATE (
COUNTROWS (
FILTER (
hraptvpd,
hraptvpd[prev_tency_end] < MIN ( DateQuery[Date] )
&& hraptvpd[next_tency_st] > MAX ( DateQuery[Date] )
)
)
)
)
Still nothing 😞
How would we do this?
@Dan492813 Maybe:
Count of property empty =
CALCULATE( COUNT(hraptvpd[prev_tency]),
USERELATIONSHIP(hraptvpd[prev_tency_end], DateQuery[Date]),
DATESBETWEEN(DateQuery[Date], hraptvpd[prev_tency_end], hraptvpd[next_tency_st])
)