Forum Discussion

lmondavi's avatar
lmondavi
Frequent Visitor
8 years ago
Solved

If statement in calculate Measure

Hi, looking for some help with a measure. I have a measure that sums a Value based on criteria filters in the Calculate statement.  I would like the measure to calculate differently (to drop one of t...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi lmondavi

     

    Does something like this help?

     

    FH_VALUE = 

VAR IsEASelected = IF(ISFILTERED('Product'[Segment]) && MAX('Product'[Segment]) = "EA" , True,False)
VAR Calc1 = Calculate(SUM(Funnel[Value]),Funnel[HalfInclusion]=1,Funnel[Forecast]="Commit",'Product'[System]="Sample",Funnel[HubSpoke]="No")
VAR Calc2 = Calculate(SUM(Funnel[Value]),Funnel[HalfInclusion]=1,Funnel[Forecast]="Commit",Funnel[HubSpoke]="No")
RETURN IF(IsEASelected,Calc1,Calc2)
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi lmondavi

 

Does something like this help?

 

FH_VALUE = 

VAR IsEASelected = IF(ISFILTERED('Product'[Segment]) && MAX('Product'[Segment]) = "EA" , True,False)
VAR Calc1 = Calculate(SUM(Funnel[Value]),Funnel[HalfInclusion]=1,Funnel[Forecast]="Commit",'Product'[System]="Sample",Funnel[HubSpoke]="No")
VAR Calc2 = Calculate(SUM(Funnel[Value]),Funnel[HalfInclusion]=1,Funnel[Forecast]="Commit",Funnel[HubSpoke]="No")
RETURN IF(IsEASelected,Calc1,Calc2)
lmondavi's avatar
lmondavi
Frequent Visitor
8 years ago

Thank you, worked like a charm!!!