Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate DAX error...

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

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

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

     

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

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