Forum Discussion

naivecalf's avatar
naivecalf
Helper III
7 years ago
Solved

Min function only accepts a column accepts a column reference as the argument number 1

Hi,   Tried to use sumx for running total with measure field, but get error,   Accu Percentage = sumx( FILTER( ALL(Query1), [Amount] >= MIN([Amount])), [Percentage])
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi naivecalf ,

 

We can create meausres as below.

Total amount = CALCULATE(COUNTA('Table'[Item]),ALLSELECTED('Table'))
Amount = CALCULATE(COUNTA('Table'[Item]))
Percentage = DIVIDE([Amount],[Total amount])

 

naivecalf's avatar
naivecalf
Helper III
7 years ago

v-frfei-msft ，

 

I already created those measures. now I need to create a new measure or column for Cumulative amount or cumulative percentage.

 

Regards

Steven