Sum a Column with filtering via measure

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/1447523/jump-to/first-unread-message 

Hi,

The simple measure can be

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

Hope this helps.