Creating percentage from a monthly report

[asoegiantoro]

Hi PowerBI Expert,

A beginner here, I wanted to ask if I can create a percentage measure for approval with different measure. The measure that I use include gender, month and location.

Year-Month = FORMAT( IF(LEN(summary_los[applied_month]) = 1, summary_los[applied_year] & "-0" & summary_los[applied_month], summary_los[applied_year] & "-" & summary_los[applied_month]), "YYYY-MM")

total_register = CALCULATE(
COUNTA('summary_los'[decision]),
ALLSELECTED('summary_los'[decision]))

count_approved =
CALCULATE(COUNTROWS(FILTER(summary_los, 'summary_los'[decision] = "Approved")))

Percentage= DIVIDE( [total_register] , summary_los[count_approved])

For the percentage, it did not work since there's a circular dependency detected. I am wondering how can I get percentage of approval. I want to see the percentage in monthly basis of approval 

My data look like: 

application_no gender cif applied_date applied_year applied_month branch_name location decision
10001 M 131522 20180113 2018 1 No Branch Name No Branch Location Approved
10004 M 132551 20180113 2018 1 No Branch Name No Branch Location Approved
10010 M 134887 20180113 2018 1 No Branch Name No Branch Location Declined
10012 M 134872 20180113 2018 1 No Branch Name No Branch Location Canceled
10014 M 132316 20180113 2018 1 No Branch Name No Branch Location Approved
10018 M 126585 20180113 2018 1 No Branch Name No Branch Location Approved
10019 M 124892 20180113 2018 1 No Branch Name No Branch Location Approved
10026 M 133385 20180113 2018 1 No Branch Name No Branch Location Approved
10028 F 127549 20180113 2018 1 No Branch Name No Branch Location Approved
10029 M 128895 20180113 2018 1 No Branch Name No Branch Location Declined
1003 M 124560 20171001 2017 10 No Branch Name No Branch Location Canceled
10030 M 134842 20180113 2018 1 No Branch Name No Branch Location Approved
10033 M 133402 20180113 2018 1 No Branch Name HCI Online 1 Approved
10034 F 134900 20180113 2018 1 No Branch Name HCI Online 1 Approved

And below is what my current dashboard looks like:

[Ashish_Mathur · Accepted solution]

Hi,

The Year-Month field should come from the Calendar Table.  There should be a relationship from the Date column of your Summary_los table to the Date column of your Calendar Table.  Also, your measure can be simplified to:

total_register = COUNTA('summary_los'[decision])

count_approved =CALCULATE([total_register],'summary_los'[decision]="Approved")