Forum Discussion

harrinho's avatar
harrinho
Helper III
7 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
Solution Sage
7 years ago

Hi harrinho,

 

Ok fine but I want to understand now your table why do you have for example for PMF Key (ACHS09) 3 times 0 for Soft hours and 3 times 32 for hard hours?

 

So to sum up for this it will be 0 for soft hours and 96 for hard hours,  correct ?

 

I will change my formula to something like this while waiting for your inputs...

 

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

Ninter

harrinho's avatar
harrinho
Helper III
7 years ago

Thanks Interkoubess. It's because these hours are based on and driven by different projects. Another example below, hopefully shows more clear. 

 

Your calculation works fine but the problem is that because I summarize this to one line, when it comes to the total row, the calculation is not applied. For example here, I jsut want to roll it up to one line, getting rid of the Projects Column

 

Then I will have the following 

But in this case I'd like the Total Allocations to return 43+38=81 instead

 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi harrinho,

     

    By my tests with the formula from Interkoubess, I cannot reproduce your issue.

     

     

    If it is convenient, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry