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

Some more info

 

I use the 2 tables to calculate a measure, the red one. But i do need the totals to show correct below the table

 

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