Forum Discussion

Kolumam's avatar
Kolumam
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Need 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

    • Kolumam's avatar
      Kolumam
      Icon for Post Prodigy rankPost Prodigy

      Actually, I entered the names wrongly. Thanks,