March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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])
)
)
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |