Cant find 'Dont summarize' on measure which has decimal values

[Anonymous]

Hi Experts,

It might sound very basic and appologies for my ignorance.

I  have measure added to a table which has decimal values. I cannot find 'Don't summarize' option once I add the measure to the table. 

Wondering what are the options to hide?

The measure DAX is as below.

Measure = 
CALCULATE( 
    DIVIDE(SUM(Table[Value]) * SUM(Table[Strength]) *  SUM(Table[Size]),90),
    FILTER(Table, Table[Value] > 0 && Table[Strength] > 0 && Table[Size] > 0)
)

[NickolajJessen · Accepted solution]

Try and turn total off in the formatting pane or try and add a condition to your measure like.
if(selecedvalue[ColumnInYourVisual]<>  Blank(), 
_measure, blank()
)

[TomMartens]

Hey @Anonymous ,

You can't change the aggregation function of explicit measures.

To suppress the calculation of measures at the total line you can use the functions HASONEVALUE(...) or ISFILTERED(...) in combination with IF wrapped around the CALCULATE(..)

Hopefully, this provides ideas on how to tackle your challenge.

Regards,

Tom