Formula/Calculation help

[3cdoug]

CalcName = DIVIDE(CALCULATE(COUNTROWS('List1), 'List1'[Cert] = "Training1" && 'List1'[Section] == "HR"), DISTINCTCOUNT(Roster[ID])) * 100

I am using this formula to calculate the individual percentages of trainings complete within PowerBI. Is there anyway to write this as a general formula, and not have it for each individual training? As it currently stands I have 20 of these same calculations and I'm sure there is a way to write this formula one time and display it to my graph.

[tamerj1 · Accepted solution]

Hi @3cdoug 

just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter

CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100