Calculate DAX error...

[Anonymous]

Hi Experts

I cannot see what i am doing wrong here this should be stright forward calcultion in DAX...

See Screem iamge i am trying to add only the Total Rev PY number if they are postive and ignore blank cell like Jan and Feb as shown...

The filter is on dimension Divestiture and month and year and YTD..... but cannot get the dax to give the right output...

% Organic Test 3 = IF(CALCULATE([Total Revenue PY],
                        FILTER(Profitability,Profitability[Divestiture]="Divestiture"))=BLANK(),BLANK(),CALCULATE([Total Revenue PY],
                        FILTER(Profitability,Profitability[Divestiture]="Divestiture")))

[AlB · Accepted solution]

Hi @Anonymous

Can you show the code for your [Total Revenue PY]? In fact sharing the pbix would be best

Isn't your code for [% Organic Test 3] exactly the same as:

% Organic Test 3 V2 =
CALCULATE (
    [Total Revenue PY],
    FILTER ( Profitability, Profitability[Divestiture] = "Divestiture" )
)