Forum Discussion

Jaco1965's avatar
Jaco1965
Frequent Visitor
7 years ago
Solved

Measure Column does not Total correct

I need the Total to add the Column value, please help  
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Jaco1965 ,

     

    In my measure I use the ";" as a separator this is related with regional settings, change it by "," and see if you are abble to use the measure.

    Total_Inv_value = SUMX(Work_Detail , [Inv_Amnt])

     

    Regards,

    MFelix

Jaco1965's avatar
Jaco1965
Frequent Visitor
7 years ago

I also tried this

 

MFelix's avatar
MFelix
Super User
7 years ago

Hi Jaco1965 ,

 

Believe that this is an issue regarding with the way you have your model / relationship between tables, can you share a sample file or a mockup or explain how the model is setup? (relationships, data, fields to be consider etc.)

 

Regards,

MFelix

    • MFelix's avatar
      MFelix
      Super User
      7 years ago

      Hi Jaco1965 ,

       

      This as to do with the context of your measures and the way you have setup the database with the link between the Resources values and the tasks and work details (nothing is incorrect) and the measures need to be readjust to give the right result.

       

      Create the following meaaures:

      Already created


      Inv_Amnt = 
    sum(Work_Detail[Work_Hrs]) * Sum(R_ClassRate[Rate])

New one
Total_Inv_value = SUMX(Work_Detail;[Inv_Amnt])

      Then use the last one to have your final result:

      As you can see changing the way the calculation is made the context changes and the result is correct when compared with the red highlited value.

       

      Again noting wrong with your setup, I tried to make a summarized table, or a group by to use in your measure but would only create more complexity on the measures.

       

      Regards,

      MFelix

      • gustavoleo's avatar
        gustavoleo
        Advocate II
        7 years ago

        Check out this blog post by SQLBI

        DAX 101: Summing values for the total

        https://rebrand.ly/correcttotal

         

        MFelix wrote:

        Hi Jaco1965 ,

         

        This as to do with the context of your measures and the way you have setup the database with the link between the Resources values and the tasks and work details (nothing is incorrect) and the measures need to be readjust to give the right result.

         

        Create the following meaaures:

        Already created


        Inv_Amnt = 
    sum(Work_Detail[Work_Hrs]) * Sum(R_ClassRate[Rate])

New one
Total_Inv_value = SUMX(Work_Detail;[Inv_Amnt])

        Then use the last one to have your final result:

        As you can see changing the way the calculation is made the context changes and the result is correct when compared with the red highlited value.

         

        Again noting wrong with your setup, I tried to make a summarized table, or a group by to use in your measure but would only create more complexity on the measures.

         

        Regards,

        MFelix


        DAX 101: Summing values for the total (@FerrariAlberto) https://www.sqlbi.com/articles/summin...