Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to extract a list of customers who has not made a purchase in the last 90 days.
For this purpose I've create the following measure, which I believe is correct:
Inactive Customers (90 days) = CALCULATE( DISTINCTCOUNT(Sales[CustomerKey]); FILTER( ADDCOLUMNS( VALUES(Sales[CustomerKey]); "SalesLast90Days"; CALCULATE(Sales[Revenue];ALL(Dates); DATESINPERIOD( Dates[Date];MAX(Sales[InvoiceDate]);-90;DAY) ) ) ;[SalesLast90Days] = 0) )
But when i pull this measure into a table with our CustomerKey as the row category, each inactive customer should recieve the value of 1, and active customers should be blank. The total of 19.945 inactive customers seems about right, but PBI is only showing me a limited amount of customers and not all.
This applies for PBI Desktop, PBI Online and with Excel Pivot table.
My initial thougt is that tt seems like I'm hitting some limitation of rows shown, but if I extract the table functions from my measure (from Filter and afterwards), and load it as a table in PBI Desktop, I get the table I'm trying to extract, which confirms my measure should be correct.
Creating a simple Distinct Count of my new table, I'm getting my desires results, so where do I go wrong?
Hi @Anonymous,
If you can please share the sample pbix file for test.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |