Forum Discussion

chrisread9907's avatar
chrisread9907
Frequent Visitor
9 years ago
Solved

SUMIF Function

Hi,   I am struggling to covert my SUMIF Excel formula to DAX,   This is my excel formula:   =SUMIFS('Slave Data'!$E:$E,'Slave Data'!K:K,"=1",'Slave Data'!$B:$B,"="&$B10,'Slave Data'!L:L,"="&H1...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago
    Sum of Duration = CALCULATE(
	SUM(SlaveData[duration]),
	FILTER(
		SlaveData,
		SlaveData[If Status Met] = 1 &&
		SlaveData[slaveid] = 1 &&
		Slavedata[datStart] = TODAY()
	)
)
Sean's avatar
Sean
Community Champion
9 years ago

It seems you want the user to enter the values in individual cells - H1 and B10?

You can't do this in PBI.

 

But you can get all results for your data set basically by using this formula

 

 

Measure =
CALCULATE (
    SUM ( Table[E] ),
    Table[K] = 1,
    ALLEXCEPT ( Table, Table[B], Table[L] )
)

This will give you the sum in column E for all combinations of columns B & L where K is 1

 

Then create a Table visualization

Add Columns B and L (make sure you select Do Not Summarize for Both) and then add the Measure

 

Hope this helps!