Percentage calculation for a Merchant X total applications for a specific status

[NB3]

Hello everyone,

I'm trying to calculate the % of declined applications for each specific merchants based on their total applications,

Here is an example

Merchant    Status          Application

     X            Approved          A

     X            Declined            B

     Z            Approved          A

     Z            Declined            B

     X            Declined            C

Right now I'm able to calculate the % of declined apps based on total apps overall and on declined applications overall but not based on total apps for each specific merchants.

Thanks for the help,

Nick

[amitchandak · Accepted solution]

@NB3 , Try a measure like

divide(calculate(count(Table[Application]), Table[Status]= "Declined"),calculate(count(Table[Application])))