Getting Null transactions eventhough I used NOT ISBLANK fucntion

[Vimal_raj]

Hello,

@PBI_Member_01 , @PBICommunity 

I am running into issue as I am getting null transactions eventhough I used NOT ISBLANK function to avoid in the price impact and Voulme Impact Column. There is a possibility either Price Impact or Volume impact is 0 and need to remove the transactions if both values are 0. 

The formula is,

Price Impact Value =

IF (

[Monthly Total Sales] > 0

&& [Total Sales Final] > 0

&& [ASP1] > 0

&& [ASP2] > 0

&& NOT ISBLANK([ASP1])

&& NOT ISBLANK([ASP2])

&& NOT ISBLANK([Total Quantity Shipped Sum]),

([ASP2] - [ASP1]) * [Total Quantity Shipped Sum],

0

)

Volume Impact: 

Volume Impact = IF(

ISBLANK([Total Quantity Shipped Sum PriorYear]) ||

ISBLANK([Total Quantity Shipped Sum]) ||

ISBLANK([Monthly Total Sales]) ||

ISBLANK([Total Sales Final]),

0,

([Total Quantity Shipped Sum] - [Total Quantity Shipped Sum PriorYear]) * [ASP1] * [AVG_GM%P1]

)

This is the screenshot of the output:

In addition, I tried the measure as Impact= [Price Impact Value] + [Volume Impact] and removing 0 in the filters for a workaround but am gettting Out of memory error.

Kindly help me to fix this issue please