Forum Discussion
Unproductive customer
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Super UserUnproductive 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