Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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#
Solved! Go to Solution.
@bhmiller89 I think you missed a close parentheses at the end of a formula.
Proud to be a Super User!
% Expired = DIVIDE( CALCULATE( DISTINCTCOUNT(TableName[Unique Identifier Column]), TableName[Is Expired] = "YES" ), CALCULATE( DISTINCTCOUNT(TableName[Unique Identifier Column]), ALL( TableName) ) )
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?
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.
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |