Forum Discussion

music583's avatar
music583
New Member
4 months ago
Solved

Calculating Percentage A Given Value of One Column Has Values In Other Columns

I need to get a table that looks like this: Employee Deadline 1 Deadline 2 Deadline 3 Person 1 Yes Yes Yes Person 2 Yes No No Person 1 Yes No No Person 3 Yes Yes Yes ...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    4 months ago

    Just wrap the denominator in a FILTER to exclude blank rows: 

    Deadline 1 % =
DIVIDE (
    COUNTROWS ( FILTER ( KEEPFILTERS ( Table1 ), Table1[Deadline 1] = "Yes" ) ),
    COUNTROWS ( FILTER ( KEEPFILTERS ( Table1 ), NOT ISBLANK ( Table1[Deadline 1] ) ) )
)

     

krishnakanth240's avatar
krishnakanth240
Super User
4 months ago

Hi music583 

Deadline 1% =

DIVIDE(CALCULATE(COUNTROWS('Table'),'Table'[Deadline 1] = "Yes"),COUNTROWS('Table'))

Change it to Percentage by selecting the measure from formatting option.

Similarly you can write measures for Deadline 2% and Deadline 3%