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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Sumif based on a value returned by a slicer

Hi,

 

I want to build a formula with sumif functionality in excel, so that sum is calculated for $ amounts for all the transactions whose period value is less than or equal to the value returned by the slicer.

 

 

For example:

sumif(Actuals!A1:T1,"<="&D4,Actuals!A6:T6)

A1:T1 = period value (1-12)

D4 = value return by slicer e.g. 9 - (I have included a measure to get the slicer value using the selected value and bringing it in a card) 

A6:T6 = $ value to be summed.

 

Will be greatly appreciated if I can have a similar formula in Power BI?

 

Thanks

Saad

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

Hi @Anonymous ,

 

See if these help

 

https://community.powerbi.com/t5/Desktop/SUMIF-function/m-p/1131402

https://community.powerbi.com/t5/Desktop/Sumif-based-on-another-table/m-p/520177

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

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

View solution in original post

2 REPLIES 2
harshnathani
Community Champion
Community Champion

Hi @Anonymous ,

 

See if these help

 

https://community.powerbi.com/t5/Desktop/SUMIF-function/m-p/1131402

https://community.powerbi.com/t5/Desktop/Sumif-based-on-another-table/m-p/520177

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

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

amitchandak
Super User
Super User

@Anonymous , very difficult to guess with formula without data. Have a date table and try like

 

measure =
var _min = minx(allselected(Date),Date[Date])
return calculate(sum(Table[column]), filter(all(Date),Date[Date]<=_min ))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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