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

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity 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" )
)