Forum Discussion

SparkDataGuru's avatar
SparkDataGuru
Frequent Visitor
3 years ago
Solved

Incorrect Sum on Matrix Table - Need Top Summary Line to Sum Instead.

Currently been running into an issue with this Matrix table below.   We have a store and it's subdepartments.  The formula to 'Recalculated New Leads' is taken by adding the Raw Leads + Partial Un...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Does this measure work?

    Measure1 = SUMX(VALUES(Data[Sub-departments]),[Recalculated new leads])

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Does this measure work?

Measure1 = SUMX(VALUES(Data[Sub-departments]),[Recalculated new leads])

  • SparkDataGuru's avatar
    SparkDataGuru
    Frequent Visitor
    3 years ago

    Thanks Ashish, looks like that revised measure works! 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      You are welcome.