Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Table not showing all rows?

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?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

    If you can please share the sample pbix file for test.


    Regards,

    Xiaoxin Sheng