Forum Discussion

3cdoug's avatar
3cdoug
Regular Visitor
3 years ago
Solved

Formula/Calculation help

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's avatar
    tamerj1
    3 years ago

    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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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