Unproductive customer

[Vidya_0505]

Hi All,

In my Power BI report, we have only demention columns (e.g Customer name , code and location) and las invoice date(taken max invoice date from sales fact table). in this report we want to show only unproductive customer, means they has not made any sales in the selected date range. Example: (if we select date range in the slicer, 1s Sept to 30th sept) Customer 001 status is delivered then they are productive customer and customer status is cancelled, returned the they're unproductive customer.  want to show only unproductive customer. Tried creating DAX but it's not working. Can anyone please help?

[v-nmadadi-msft]

Hi @Vidya_0505 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @Vidya_0505 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Kedar_Pande]

Unproductive Customers =
VAR MaxInvoiceDate = MAX('Sales'[Invoice Date])
VAR SelectedStart = MIN('Date'[Date])
VAR SelectedEnd = MAX('Date'[Date])
RETURN
IF(
NOT(ISBLANK(MaxInvoiceDate)) &&
MaxInvoiceDate >= SelectedStart &&
MaxInvoiceDate <= SelectedEnd &&
[Status] IN {"Cancelled", "Returned"},
1,
0
)

Then add a visual-level filter showing only where this measure = 1.

If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...