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

[naivecalf]

Hi,

Tried to use sumx for running total with measure field, but get error,

Accu Percentage = sumx(

FILTER(

ALL(Query1),

[Amount] >= MIN([Amount])),

[Percentage])

[Ashish_Mathur]

Hi,

Share some data, describe the business question and show the expected result.

[naivecalf]

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]

Hi,

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

[naivecalf]

Hi,

please download here for Powerbi,  https://emcoreus-my.sharepoint.com/:u:/g/personal/steven_zhang_emcoreus_onmicrosoft_com/EVAeQ2TUXadJ...

 here for data source, https://emcoreus-my.sharepoint.com/:x:/g/personal/steven_zhang_emcoreus_onmicrosoft_com/EfwsNdvQ1PZO...

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[naivecalf]

@Ashish_Mathur ,

thank you, it is working.

Regards

Steven

[Ashish_Mathur]

You are welcome.

[v-frfei-msft]

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]

@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

[Anonymous]

Hi @naivecalf ,

Don't know how your data looks like. 

But you can refer this post and give a shot.

https://community.powerbi.com/t5/Desktop/Cumulative-Totals-for-measures/m-p/743814#M358599

If this is of not much help than please provide us some sample data.

Thanks,

Tejaswi

[naivecalf]

Hi @Anonymous ，

here is my data,