Forum Discussion
naivecalf
Helper III
Helper IIIMin 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])
11 Replies
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
naivecalfHi Anonymous ，
here is my data,
- Ashish_Mathur
Super User
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.
v-frfei-msftCommunity Support
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])
