Forum Discussion
Calculating % Compete with Conditions
Good day, I'm trying to create a new measure that shows the % percent of effective documents out of the total number of documents for a visual in Power BI. These measures seem to be off and I'm not s...
You can try this as well to count total # of documents with effective status over total # of documents.
Eff% = CALCULATE(COUNTA(TableName[Document Status]), TableName[Document Status]="Effective")/ calculate(COUNTA(TableName[Document Status]))