Trying to use COUNT or SUM functions

[bhmiller89]

I have a calculated colum called "Is Expired" where the values are spit out either being "YES" or "NO."

I am trying to calculated the % that are expired but no combination seems to work.

I want: #"YES"/ Total#

[KHorseman]

% Expired = DIVIDE(
	CALCULATE(
		DISTINCTCOUNT(TableName[Unique Identifier Column]),
		TableName[Is Expired] = "YES"
	),
	CALCULATE(
		DISTINCTCOUNT(TableName[Unique Identifier Column]),
		ALL( TableName)
	)
)

[bhmiller89]

It's giving me errors.  What column/type of column should "TableName[Unique Identifier Column]" be?

[KHorseman]

@bhmiller89 that column's data type shouldn't matter. It's whatever column represents the thing you're trying to count that is marked as expired.

You are adding this as a measure and not a column right? What does the error say?

[bhmiller89]

@KHorseman I get "Too many arguments were passed to the DISTINTCOUNT function.  The maximum argument count for the function is 1"

[KHorseman · Accepted solution]

@bhmiller89 I think you missed a close parentheses at the end of a formula.