Forum Discussion
Min function only accepts a column accepts a column reference as the argument number 1
Hi,
Share some data, describe the business question and show the expected result.
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.
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])
I already created those measures. now I need to create a new measure or column for Cumulative amount or cumulative percentage.
Regards
Steven
Hi,
Share the link from where i can download your PBI file.
Hi,
please download here for Powerbi, https://emcoreus-my.sharepoint.com/:u:/g/personal/steven_zhang_emcoreus_onmicrosoft_com/EVAeQ2TUXadJkWb6sFqGeS8Brwnmuf2dNCuUAnvf-oj6YQ
here for data source, https://emcoreus-my.sharepoint.com/:x:/g/personal/steven_zhang_emcoreus_onmicrosoft_com/EfwsNdvQ1PZOqOv7pVe-VmYBvQfaT-4yYfsYkXDOwniWoA
