Forum Discussion

chesterraepined's avatar
chesterraepined
Helper I
8 years ago
Solved

Need a measure for table visual

I need a measure that will show the percentage for only "Hit" and "Missed" and then blank or 0 will show for "No deadline set". 

The computation for Hit should be Request Completed divided by Sum of Hit and Missed (2318 / 2524 =  0.92). Same with Missed it should be (206 / 2524 = 0.08).

 

 

Target = column

Request Completed = COUNTROWS(CustomerUpdates)

 

 

 

 

Hope this is possible.

Thanks in advance!

 

 

Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi chesterraepined,

     

    Please try this measure with my table called Table1:

    Measure  = if(SELECTEDVALUE(Table1[target])="No deadline set", 0,DIVIDE(SUM(Table1[Requested Completed]),CALCULATE(SUM(Table1[Requested Completed]), Table1[target] in {"Hit","Missed"}),BLANK()))

     

    Hope it helps but experts can find more elaborate formula for you.

     

     

    Ninter 

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi chesterraepined,

     

    Please try this measure with my table called Table1:

    Measure  = if(SELECTEDVALUE(Table1[target])="No deadline set", 0,DIVIDE(SUM(Table1[Requested Completed]),CALCULATE(SUM(Table1[Requested Completed]), Table1[target] in {"Hit","Missed"}),BLANK()))

     

    Hope it helps but experts can find more elaborate formula for you.

     

     

    Ninter 

    • chesterraepined's avatar
      chesterraepined
      Helper I
      8 years ago

      Hi Interkoubess thanks for the reply.

      The measure seems fine but the total is somehow different. The total 5708 was also divided to the sum of Hit and Missed (5708 / 2524 = 226.15%) . The Total should only be 100%