- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate with filter date value greater then date measure
Hi experts:)
we are onboarding customers to use self service orders app.
I have this Sales table and i'm trying to calculate for each customer how many orders he placed NOT from the App since he was onboarded.
customer | order date | app order |
1111 | 01/05/2023 | yes |
1111 | 22/05/2023 | no |
1111 | 03/06/2023 | yes |
1112 | 01/04/2023 | yes |
1112 | 15/04/2023 | no |
1112 | 10/06/2023 | no |
1113 | 10/07/2023 | no |
1114 | 19/05/2023 | yes |
1114 | 10/10/2023 | no |
1114 | 01/11/2023 | yes |
1114 | 19/12/2023 | no |
what i did was:
measure 1:
App start date = calculate (min(Sales[order date]) , Sales[app order]="yes")
measure 2:
now i want to count the number of orders "not from app" since app start date for each customer:
orders since app = calculate(count(Sales[order date]),Sales[app order]="no",Sales[order date]>[App start date])
i get this error for measure 2 :
A function ‘calculate‘ has been used in a True/False expression that is used as a table filter expression. This is not allowed.
which i believe refers to this part: Sales[order date]>[App start date]
how should i write this measure?
thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

orders since app =
VAR __appstartdate = [App start date]
RETURN
CALCULATE (
COUNT ( Sales[order date] ),
Sales[app order] = "no",
Sales[order date] > __appstartdate
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

orders since app =
VAR __appstartdate = [App start date]
RETURN
CALCULATE (
COUNT ( Sales[order date] ),
Sales[app order] = "no",
Sales[order date] > __appstartdate
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-15-2024 11:09 AM | |||
09-28-2023 06:14 AM | |||
01-26-2024 04:56 AM | |||
02-19-2024 02:30 AM | |||
07-10-2024 02:08 PM |