Forum Discussion

Juju123's avatar
Juju123
Icon for Helper III rankHelper III
2 years ago
Solved

Sumx not return good total

Hi,  I have a problem with SUMX fonction. I have a table in which i want to sum calculated column.  I create a DAX formula for calculated column :  TEST = IF([Measure]<>0,1,0) Then i want to ha...
General Comment
Need Help
Tips and Tricks
  • Juju123's avatar
    Juju123
    2 years ago

    Thanks you so much ! it's works

Juju123's avatar
Juju123
Icon for Helper III rankHelper III
2 years ago

Thanks you so much ! it's works

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.

  • Juju123's avatar
    Juju123
    Icon for Helper III rankHelper III
    2 years ago

    Ashish_Mathur,

    J'ai appliqué la formule dax sur un plus gros échantillon de données et le rapport est très très lent.

    Est-il possible de remplacer la fonction résumé par une autre ou d'utiliser une façon de faire en DAX ?

  • Juju123's avatar
    Juju123
    Icon for Helper III rankHelper III
    2 years ago

    I find a solution

     

    I create a concatenate column in database and after i use only this dax formula

    NEW_NUMBER_REF = COUNTROW('TABLE'[KEY_CARD])