Forum Discussion

AlexGallet01's avatar
AlexGallet01
Icon for Helper IV rankHelper IV
9 years ago

Problem with formula

Hello,   I have a problem with my formula and i don't understand why it's not possible to do this.   DIFF = CALCULATE(SUM(Commandes[LCCNVALCDE]);TEST[References.ValeursUtilise])-CALCULATE(SUM(Com...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi AlexGallet01

 

 

Make this as a calculated column first:

 

Some column = IF(TEST[References.ValeursUtilise]<>"H-OF";TEST[References.ValeursUtilise]+1;BLANK())

 

 

Then create your measures after and adjust them to your newly calculated column.

 

Let me know how it goes.

 

Best,

Martin

  • AlexGallet01's avatar
    AlexGallet01
    Icon for Helper IV rankHelper IV
    9 years ago

    Hi ValubiMartin,

     

    I can't do this column i have an error message with value before H-OF.

    The message speak about impossible to convert my value type of string in int.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Can you send me a picture of how your data is stored?