Sumif

[jeje]

I'm trying to get the total number of status column ( complete, not complete, partial complete) and the values in column count, how do i place this in measure in PBI? Thanks for the help.

[V-lianl-msft · Accepted solution]

Try to create measures like below:

Sum of count = SUM('Table'[Count])

Percentage = 

DIVIDE(
        [Sum of count],
		CALCULATE(SUM('Table'[Count]),ALLSELECTED('Table'))
		
	)

[Greg_Deckler]

@jeje Basic syntax equivalent is SUMX(FILTER(...),...) or CALCULATE(SUM(...), FILTER(...))

Excel to DAX Translation - Microsoft Power BI Community