Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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])
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
17 | |
10 | |
10 | |
8 | |
6 |
User | Count |
---|---|
20 | |
18 | |
16 | |
13 | |
10 |