HasOnFilter with multiple if conditions

[Anonymous]

Hi I have calculated measure based on multiple conditions. Instead of giving total of calculated column it is applying same logic for total as well and gives incorrect sum.

below is my calculated measure. I tried to put Hasfilter on it but it is not working as well.

Difference =

IF(SUM('2018 Invoice'[Month]) < 9  &&  SUM('August 2019'[Amount]) <> BLANK(),

( SUM('August 2019'[EUR Amount]) - SUM('2018 Invoice'[Revenue])) ,

IF(SUM('2018 Invoice'[Month]) > 7  &&  SUM('August 2019'[Amount]) <> BLANK() ,(sum(Opportunity[Revenue])+sum('August 2019'[Amount]))-sum('2018 Invoice'[Revenue]) ))

[v-xuding-msft]

Hi @Anonymous ,

Please see this post regarding How to Get Your Question Answered Quickly:

 https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

May be parenthesis is causing the incorrect Data.

You can provide some sample data for us  with a screesnhot of expected result. 

It would be easy for us to get back with your solutions quickly.

Thanks,

Tejaswi