Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
10 years ago
Solved

Trying to use COUNT or SUM functions

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#

Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago
    % Expired = DIVIDE(
	CALCULATE(
		DISTINCTCOUNT(TableName[Unique Identifier Column]),
		TableName[Is Expired] = "YES"
	),
	CALCULATE(
		DISTINCTCOUNT(TableName[Unique Identifier Column]),
		ALL( TableName)
	)
)
    • bhmiller89's avatar
      bhmiller89
      Icon for Helper V rankHelper V
      10 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        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?