Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bhmiller89
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

@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
KHorseman
Community Champion
Community Champion

% 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!




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

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




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

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




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.