Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
AndréNextFit
Frequent Visitor

FILTER after using USERELATIONSHIP function does not work correctly

I need to get the number of customers who canceled, then I need to calculate the reversed accumulated. The problem is that the first measurement returns all blank values, without any errors.

AndrNextFit_0-1673457066269.pngAndrNextFit_1-1673457197214.png

Cancel =
CALCULATE(
DISTINCTCOUNT(dCustumer[Custumer ID]),
USERELATIONSHIP('dCalendar'[Date ID],dCustumer[Cancel Date]),
FILTER(
dCustumer,
dCustumer[Entry Date] < MAX('dCalendar'[Date ID])))

Inverted Acumulated=
CALCULATE(
[Cancel],
FILTER(
ALLSELECTED('dCalendar'),
EOMONTH('dCalendar'[Date ID],0) >= MIN('dCalendar'[Date ID])
)
)

2 REPLIES 2
lbendlin
Super User
Super User

something like this (pseudo code)

Inverted Acumulated=
var mxd = MAX('dCalendar'[Date ID])
var mind = MIN('dCalendar'[Date ID])
return CALCULATE(
DISTINCTCOUNT(dCustumer[Custumer ID]),
USERELATIONSHIP('dCalendar'[Date ID],dCustumer[Cancel Date]),
dCustumer[Entry Date] < mxd,
EOMONTH('dCalendar'[Date ID],0) >= mind
)

Hello, i try your method and dont work again, my perception is that dax has a limitation in this case. After this i make a query in postgresql and work.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors