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

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

I am not comfortable with using that platform.

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

      Thanks Ashish_Mathur 

      i see the pbi and your test and I will back

       

      On the other hand I would like to know why you have 2 for the month of June 2023 and not 1?

       

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

        Test the result and study the solution thoroughly.  If there are problems, then clearly show the problem and also the expected result.