Search code examples
daxtabular

how do i hide the grand total from in tabular model's measurement using dax?

I am using DAX to make a formula in the tabular model, but how can i hide the grand total part of that measure? i see grand total part whenever i open the pivot table and put the measurements. However i would like to hide the grand total part. How can i do that? Do i have to use dax formula for it, or do i have to set up in the tabular model?

12 Local:=CALCULATE (
    [Local],
    DATESINPERIOD(
        Calendar[Date] ,
        MAX ( Calendar[Date] ),
        -12,
        MONTH
    )
)
Solution

  • You have to turn off grand totals in the pivot table. Even if you write a measure that returns blank at the grand total level, you would just see a grand total line with nothing in it but the label.

    Totals in pivots.