Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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])
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
15 | |
14 | |
13 | |
9 |
User | Count |
---|---|
60 | |
23 | |
22 | |
19 | |
13 |