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

MFelix's avatar
MFelix
Super User
7 years ago

Hi Jaco1965 ,

 

Being you measure a multiplication of values you need to use a SUMX formula should look something like this:

 

Inv_Amnt = SUMX(Work_Detail; Work_Detail[Work_Hrs] * R_ClassRate[Rate])

Be awar that you may need to adjust the parameters of the measure.

 

Regards,

MFelix

  • Jaco1965's avatar
    Jaco1965
    Frequent Visitor
    7 years ago

     

    I am still doing something wrong

     

     

  • Jaco1965's avatar
    Jaco1965
    Frequent Visitor
    7 years ago

     

    I also tried this

     

     

  • 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