Forum Discussion
Solved
measure
i would like to know how to call out another measure to use in another measure. i have created below: count_product = SUMX(all('table'[column1]),calculate(COUNT('table'[Column1]))) and cumulative...
Hope this helps! :smileyhappy:
New Table = SUMMARIZE ( 'Table', 'Table'[Type], "Count of Type", COUNTROWS ( 'Table' ), "Type Rank by Count", RANKX ( ALL ( 'Table'[Type] ), CALCULATE ( COUNTROWS ( 'Table' ) ) ) ) Cumulative Sum Column = CALCULATE ( SUM ( 'New Table'[Count of Type] ), FILTER ( 'New Table', 'New Table'[Type Rank by Count] <= EARLIER ( 'New Table'[Type Rank by Count] ) ) )Continued here...
http://community.powerbi.com/t5/Desktop/cumulative-sum/m-p/136762/highlight/false#M58688
Here is the visual of my data. the last column is the one that i am trying to create.
i tried the summarize but then there is an error that says about max when i used the column defined in the summarize
| Type | count_product | Cumulative sum |
| 1 | 500 | 500 |
| 3 | 330 | 830 |
| 2 | 220 | 1050 |
Hope this helps! :smileyhappy:
New Table =
SUMMARIZE (
'Table',
'Table'[Type],
"Count of Type", COUNTROWS ( 'Table' ),
"Type Rank by Count", RANKX ( ALL ( 'Table'[Type] ), CALCULATE ( COUNTROWS ( 'Table' ) ) )
)
Cumulative Sum Column =
CALCULATE (
SUM ( 'New Table'[Count of Type] ),
FILTER (
'New Table',
'New Table'[Type Rank by Count] <= EARLIER ( 'New Table'[Type Rank by Count] )
)
)
Continued here...
http://community.powerbi.com/t5/Desktop/cumulative-sum/m-p/136762/highlight/false#M58688
Hi Sean, i tried this but it says that the DAZ has error.
Post the formula you are using
Sean wrote:
Post the formula you are using
Here is the error. the first one i think is ok, but hte next call out has an error.
