cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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#

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Highlighted
Super User I
Super User I

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

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

Highlighted

@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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

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

Highlighted

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors