Forum Discussion

sks2701's avatar
sks2701
Helper III
5 years ago
Solved

Calculation

Hi- I have a data set from which I have to show in visuals the below calculation- can someone please help , how this can be achieved   Dropped Rate Total count of dropped / Total count   Closed ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, sks2701 

    According to your description, you can try these measures:

    Dropped Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _droppedcount=COUNTX(FILTER('Table',[Overall Status]="Dropped"),[ID])

return DIVIDE(_droppedcount,_tatalcount)
    Closed Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _closedcount=COUNTX(FILTER('Table',[Overall Status]="Closed"),[ID])

return DIVIDE(_closedcount,_tatalcount)
    Approval Rate =

var _tatalcount=COUNTX(ALL('Table'),'Table'[ID])

var _approvalcount=COUNTX(FILTER('Table',[Overall Status]="In progress"||[Overall Status]="Under review"),[ID])

return DIVIDE(_approvalcount,_tatalcount)

    You can set the measure type to “Percetage”, like this:

     

    And you can get what you want, like this:

     

    You can download my test pbix file here

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

camargos88's avatar
camargos88
Community Champion
5 years ago

sks2701 ,

 

You can use these measures in a card:

_DroppedRate = DIVIDE(CALCULATE(COUNTROWS('Table'), 'Table'[Overall Status] = "Dropped"), CALCULATE(COUNTROWS('Table'),  ALL('Table'[Overall Status])), 0)

_ClosedRate = DIVIDE(CALCULATE(COUNTROWS('Table'), 'Table'[Overall Status] = "Closed"), CALCULATE(COUNTROWS('Table'),  ALL('Table'[Overall Status])), 0)

_ApprovalRate = DIVIDE(CALCULATE(COUNTROWS('Table'), 'Table'[Overall Status] = "In progress"), CALCULATE(COUNTROWS('Table'),  ALL('Table'[Overall Status])), 0)
  • sks2701's avatar
    sks2701
    Helper III
    5 years ago

    camargos88 : thanks a ton this really helped , however for approved rate the formula would be 

    (Total count of In progress + Total count of under review)/ total count

     

    Could you help for this too- thank you again!