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
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