Forum Discussion

Seliebl's avatar
Seliebl
New Member
6 years ago

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...
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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