Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Different formula in total row

Hi! I want a column that uses one calculation on each row and subtotal row, but a different calculation on the total row. Example from Contoso sample data set: In the Total row in the right ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    GM pct total =
    SUMX (
    SUMMARIZE (
    Sales,
    Geography[ContinentName],
    Product[ProductName],
    'Date'[Year]
    ),
    [GM pct]
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I guess a shorter version of my question is:

Can you manipulate the values of MEASURES at different total levels in a visualisation?

I know you can do it to COLUMN values, with SUM and SUMX.

But I’m not sure that DAX has any functions that will allow me to manipulate a MEASURE in this way.

Thanks for any comments 😀