Need to create measure to do some calculation based out of column fields

[bhavsar08]

Hello All,

i have 2 columns - Status 1 and application

Status 1 column have texts - Green, Red, Yellow

Application column have 2 fields - Yes, No

i need to create measure of - Sum of total application - sum of Red  and then  sum of Yes /(devide) by total 

[_AAndrade · Accepted solution]

Hi @bhavsar08,

According to my understanding of your request I build this sample data:

With this data table I wrote this measures:

Sum Application = SUM(f_data[Value])

Sum Red = 
CALCULATE(
    [Sum Application],
    FILTER(
        ALLSELECTED(f_data),
        f_data[Status] = "RED"
    )
)

Sum Yes = 
CALCULATE(
    [Sum Application],
    FILTER(
        ALLSELECTED(f_data),
        f_data[Application] = "Yes"
    )
)

Total Applications = 
CALCULATE(
    [Sum Application],
    ALL(f_data)
)

% Yes = DIVIDE([Sum Yes], [Total Applications])

The final output was this:

[_AAndrade]

Hi @bhavsar08,

Could you please provide some data and the expectec output?