Forum Discussion

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

IF Statement

Hi,    I have the following table with measures from two different sources, however, joins on ID are fine and working.   My issue is that the if statement i have built doesn't return any result. ...
Need Help
Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
8 years ago

Hi harrinho,

 

I have a question to better understand your request.

Why 4 conditions because I only see 1 if ( If I am correct):

1. If Soft Hours > Hard Hours, return Soft+Hard else Hard hours

 

Please check this and let us know.

 

Ninter

 

 

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

Indeed, I just deployed it in detail to explain the context better :) 

 

I amended the query as per below 

 

Total Allocations = IF(CALCULATE(SUM('CLARITY ALLOCATIONS'[Soft Hours]))>CALCULATE(SUM('CLARITY HARD ALLOC'[Hard_Hrs])),CALCULATE(SUM('CLARITY ALLOCATIONS'[Soft Hours])+SUM('CLARITY HARD ALLOC'[Hard_Hrs])),CALCULATE(SUM('CLARITY HARD ALLOC'[Hard_Hrs])))

But I get odd results again