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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Share the link from where i can download your PBI file.