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

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