Forum Discussion

Robfen1's avatar
Robfen1
Frequent Visitor
6 years ago
Solved

Sum a Min Measure

Hi all -   I have created a Measure and called in base pay : Base Pay:=1000   I then calculated another Measure from a table column called Weekly Pay:=Table[column]/52   Then created another me...
  • AlexAlberga727's avatar
    AlexAlberga727
    6 years ago

    Have you thought about creating a calculated column to identify the MIN value for each record. Then create a measure to SUM this column?

Robfen1's avatar
Robfen1
Frequent Visitor
6 years ago

Thanks Greg and for the fast reply - I will look at those this afternoon!

  • Robfen1's avatar
    Robfen1
    Frequent Visitor
    6 years ago

    I am having trouble because there are two measures involved i think - 

     

    ...in the false argument of the hasonefilter function i feel like i have to go all the way back to the table column root to get the proper aggregation...not sure if that makes any sense??

     

    Lmk - can alwyas add more info.

     

    Thanks!

    • AlexAlberga727's avatar
      AlexAlberga727
      Icon for Resolver II rankResolver II
      6 years ago

      Have you thought about creating a calculated column to identify the MIN value for each record. Then create a measure to SUM this column?