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

Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

Hello Juju123 ,

 

Please check the data type of your measure and if it is general or text change it to whole number that may help you in acheiving your requirement.

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

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

    Hi Kishore_KVN, 

    My column it's measure and i have a good forma :