Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
If anyone can help I'd be enternally grateful.
Solved! Go to Solution.
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
Hi Dan
kindly share a screenshot of the data model tab
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 @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] )
)
)
Even if I remove the relationships it doesn't count anything 😞
Hi @Anonymous
which date column are you using in your visual?
Month-Year in the DateQuery table. I have tried with a blank table and it doesn't show anything
@Anonymous
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 😞
Good Morning @Anonymous
I need to connect with you possible on Monday
How would we do this?
@Anonymous 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])
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
20 | |
11 | |
10 | |
9 | |
7 |