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 perc...
  • 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

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