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.
I can see this question has been asked before. Somehow it's not working.
I want to count from "open/closed status" and "phase"
Open/close status criteria = "open" and "closed"
Phase = "4 - Delivery"
I have managed to search with one criterion only.
CALCULATE(COUNTROWS(Project), SEARCH("closed", Project[open/closed Status],,0)>0)
Solved! Go to Solution.
@Anonymous
= CALCULATE(
COUNTROWS(Project),
Project[open/closed Status] IN {"Open", "Closed"},
Project[Phase] = "4 - Delivery",
Project[Est. Execution/Project start date] >= DATEVALUE("01-01-2020"),
Project[Est. Execution/Project start date] <= DATEVALUE("31-12-2020")
)
You can also use DATE(2021,12,31) instead of DATEVALUE("31-12-2020")
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
@Anonymous
= CALCULATE(
COUNTROWS(Project),
Project[open/closed Status] IN {"Open", "Closed"},
Project[Phase] = "4 - Delivery",
Project[Est. Execution/Project start date] >= DATEVALUE("01-01-2020"),
Project[Est. Execution/Project start date] <= DATEVALUE("31-12-2020")
)
You can also use DATE(2021,12,31) instead of DATEVALUE("31-12-2020")
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi @AlB
This is working perfectly.
I also a have column with dates I would like to include e.g. >= 01-01-2020 <=31-12-2020 - can this also be done?
= CALCULATE(
COUNTROWS(Project),
Project[open/closed Status] IN {"Open", "Closed"},
Project[Phase] = "4 - Delivery",
Project[Est. Execution/Project start date] >= "01-01-2020" & <= "31-12-2020"
)
Hi @Anonymous
The condition is not completely clear. Try:
CALCULATE (
COUNTROWS ( Project ),
Project[open/closed Status] IN { "open", "closed" },
Project[Phase] = "4 - Delivery"
)
or
CALCULATE (
COUNTROWS ( Project ),
Project[open/closed Status] = "closed",
Project[Phase] = "4 - Delivery"
)
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |