Sum a Column with filtering via measure

[CharnanK]

I have a large column which I want to SUM, but only want to SUM those rows with values above 6.01

Please??

[Ashish_Mathur]

Hi,

The simple measure can be

Measure = calculate(sum(Data[Total XS Leave weeks]),Data[Total XS Leave weeks]>6)

Hope this helps.

[danextian]

Hi @CharnanK ,

Please try this:

=
CALCULATE (
    SUM ( 'table'[column] ),
    FILTER ( 'table', 'table'[column] > 6.01 )
)

If this not what you're looking for, please elaborate your use case, provide a sample data (not an image) and your expected result. This sticky post should serve as a guide: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...