Forum Discussion
Kolumam
Post Prodigy
8 years agoNeed help with a measure
Hi All,
I am using this measure to calculate the size based on the filters. The size that I should get is 59.37 for Quarter 3 but it displays some crazy value of 10. Could you please point out what's wrong with this formula?
High Likelihood = CALCULATE(SUM(Opportunity[Size]),
FILTER(Opportunity, AND(Opportunity[High_Liklihood]="TRUE",
OR(Opportunity[StageName]="Opportunity",OR(Opportunity[StageName]="Negotiation",
OR(Opportunity[StageName]="Terms",
Opportunity[StageName]="Contract"))))))
Please see the below chart to understand better.
2 Replies
- v-chuncz-msft
Community Support
- Kolumam
Post Prodigy
Actually, I entered the names wrongly. Thanks,