Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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.
| User | Count |
|---|---|
| 58 | |
| 46 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 46 | |
| 22 | |
| 22 |