topic Sumif based on a value returned by a slicer in DAX Commands and Tips

Sumif based on a value returned by a slicer

Anonymous — Wed, 15 Jul 2020 07:11:22 GMT

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

Re: Sumif based on a value returned by a slicer

amitchandak — Wed, 15 Jul 2020 07:19:28 GMT

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

Re: Sumif based on a value returned by a slicer

Anonymous — Wed, 15 Jul 2020 07:37:17 GMT

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!