Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CharnanK
Helper I
Helper I

Sum a Column with filtering via measure

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

CharnanK_0-1698891632888.png

 

Please??

 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

The simple measure can be

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
danextian
Super User
Super User

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... 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors