Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
i’ve got a problem with a measure which should only consider positive values from a target-actual comparison:
Measure =
(SUMX (
FILTER (Job, Plan[BudgetControl-Delta] > 0),
Plan[BudgetControl-Delta]
) )
So the measure replaces negative values with blanks. But unfortunately in total it seems that the measure also includes the negative values:
Any ideas, how to improve the measure?
Thank you
Chris
Solved! Go to Solution.
Hi @Chris_23
Your measure looks good except that the first table parameter should be 'Plan' rather than 'Job' I think.
Measure =
SUMX (
FILTER (Plan, Plan[BudgetControl-Delta] > 0),
Plan[BudgetControl-Delta]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Chris_23
Your measure looks good except that the first table parameter should be 'Plan' rather than 'Job' I think.
Measure =
SUMX (
FILTER (Plan, Plan[BudgetControl-Delta] > 0),
Plan[BudgetControl-Delta]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
37 |