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.

naivecalf's avatar
naivecalf
Helper III
7 years ago

Hi Ashish_Mathur ,

 

please see attached file.

I have a serial list, need to count all column as total amount, and then count column by Type as amount. want to create a P-chart for percentage.  Accumulated amount/Total amount.

Listed a sample.

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