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...

Need Help

Sean

9 years ago

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

Forum Discussion

measure

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure