Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a calculated column using another calculated column

Hi,   I'm confronting a problem that I'm not able to solve. I request your help on this.    I created a column by using the formula Impact_Mean= calculate(SUM(Append1[Total Impact])/SUM(Append1[...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    Could you please try below code:-

    TEST =
SWITCH (
    TRUE (),
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 4, "4",
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 3, "1",
    TRUNC ( Append1[Impact_Mean] ) = 5
        && TRUNC ( Append1[Probability_Mean] ) = 5, "2",
    "0"
)

    BR,

    Samarth

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

Could you please try below code:-

TEST =
SWITCH (
    TRUE (),
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 4, "4",
    TRUNC ( Append1[Impact_Mean] ) = 4
        && TRUNC ( Append1[Probability_Mean] ) = 3, "1",
    TRUNC ( Append1[Impact_Mean] ) = 5
        && TRUNC ( Append1[Probability_Mean] ) = 5, "2",
    "0"
)

BR,

Samarth

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    Thank you for the suggestion. It is giving me Non-Zero values in Column "Test" but these values are not correct as per the condition applied

    Thank you in advance

    • Samarth_18's avatar
      Samarth_18
      Community Champion
      4 years ago

      Anonymous Is it possible for you to share your PBIX file after removing sensitive data?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        After correcting the data type and applying Trunc, It is working fine now. 

        Thank you very much for your help.