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()
	)
)
InsightSoporte's avatar
InsightSoporte
Regular Visitor
7 years ago

I have moths looking for a solution about this mesure or calculate.

 

This table has a group of variable  in multiple columns in excel file , i need to find each variable in all Q1_# and count, also and get % for the sum of all variable.

 

In the image you can find the chart to expect and the output table.

 

Using "=COUNTIF(EXCELTABLE,VARIABLETOFIND)/COUNTA(Q1_#)" 
*Q1_# All columns Q1