Forum Discussion

GideonM's avatar
GideonM
New Member
4 years ago
Solved

Aggregating budget values at the correct level

My data is a big flat file in Excel containing Sales figures.   Category Subcategory Product Sales Budget Beverages Beers Stella Artois £20,081 £62,800 Beverages Beers John Smith...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    GideonM  use this as a measure

    Measure 3 = sumx(SUMMARIZE(t1,t1[Category],t1[Budget]),t1[Budget])

     

     

      

smpa01's avatar
smpa01
Community Champion
4 years ago

GideonM  use this as a measure

Measure 3 = sumx(SUMMARIZE(t1,t1[Category],t1[Budget]),t1[Budget])

 

 

  

  • GideonM's avatar
    GideonM
    New Member
    4 years ago

    Thanks smpa01 that looks great!