Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 sure what I'm missing.
First, I wanted to select a condition that counted all the items in the list "GOP & S-GOP Traceability", but only filtered on the "Document Status" field where items are tagged as "Effective". Then, I wanted to divide to the total number of "Effective" documents by the Total Number of Documents to get a percentage.
Written out: Total # of Effective Documents/Total # of Documents = % Completed
Below is my attempt to write these formulas:
I'm using COUNT A because these fields do not contain numbers, but words.
Any help is greatly appreciated. Thanks!
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]))
Hi @Seliebl ,
Starting with a table called Trace, try this.
Pct effective =
VAR _num =
CALCULATE ( COUNTROWS ( Trace ), Trace[Document Status] = "Effective" )
VAR _all =
COUNTROWS ( ALL ( Trace ) )
RETURN
DIVIDE ( _num, _all )
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |