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.
Hello!
I'm creating a measure called Adj New Biz and I would like it to function as such:
SUMIF (Project_Group_ID = NBIZ) OR ((Project_Group_ID = INT) AND CategoryName = "Marketing/New Business" or "Business Development"
So you see I'm just making sure all of INT's hours that were related to new business and business development are added into everything that is under project group ID NBIZ.
Not sure of an easier way to do this. I do not want to make a table, but would rather have a measure. Still pretty new to DAX. Any advice? Am I asking for two much from a measure? Should I try and code a table instead?
Solved! Go to Solution.
You are right to try to this as a measure. Here is an expression that should work.
Sum Measure =
CALCULATE (
SUM ( Table[Hours] ),
FILTER (
ALLSELECTED (
Table[Project_Group_Id],
[CategoryName]
),
OR (
Table[Project_Group_Id] = "NBIZ",
AND (
Table[Project_Group_Id] = "INT",
Table[CategoryName]
IN {
"Marketing/New Business",
"Business Development"
}
)
)
)
)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You are right to try to this as a measure. Here is an expression that should work.
Sum Measure =
CALCULATE (
SUM ( Table[Hours] ),
FILTER (
ALLSELECTED (
Table[Project_Group_Id],
[CategoryName]
),
OR (
Table[Project_Group_Id] = "NBIZ",
AND (
Table[Project_Group_Id] = "INT",
Table[CategoryName]
IN {
"Marketing/New Business",
"Business Development"
}
)
)
)
)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |