Forum Discussion
theo
Helper III
Helper IIImeasure
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
Sean
Community Champion
Community ChampionHope 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
theoHelper III
Helper IIIHi Sean, i tried this but it says that the DAZ has error.
- Sean
Post the formula you are using
- theo
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.
- Phil_Seamark
Microsoft Employee
Hi theo,
I see the issue. Seans instructions are 2 steps that need to be done separately.
First create a table like this
New Table = SUMMARIZE ( 'Table', 'Table'[Type], "Count of Type", COUNTROWS ( 'Table' ), "Type Rank by Count", RANKX ( ALL ( 'Table'[Type] ), CALCULATE ( COUNTROWS ( 'Table' ) ) ) )and then once you have the table, create a column on that table like this
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] ) ) )
- Phil_Seamark
