how to count number of "yes" generated based on the arrival time

[Chinthaka]

Hi, 

I want to calculate the allowance for officers based on the time arrived to work. 

Below is the DAX table view for reference 

Based on the time of arrival, I have derived "yes" and "no" for ontime arival as seen below . 

Now I want to calculate the allowance given for each member based on "Yes", "No" result. 

eg. member 01 - only one "yes". So payebale for 10 days should be number of Yes x 250 (1 x 250= 250)

      Member 02 - only seven "Yes" So payebale for 10 days should be numbr of Yes x 250 (7 x 250= 1750)

Is there any way that i can convert yes in to values which i can add and multiply 

Thanks

Chinthaka

[Fowmy · Accepted solution]

@Chinthaka 

Try this, replace your table and column names:

Allowance = 
SUMX (
    VALUES ( Calendar[Date]),
    IF( [yourmeasure]="Yes" , 250 )
)

[Chinthaka]

@Fowmy 

This works great. Thank you.