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?