Need some help

[Fourdy27]

I'm not sure if I'm in the right section—newbie here—but I have a question regarding Power BI. I have data on maternity leave that currently counts the number of "maternity leave" days per week. For example, if someone takes 5 days of maternity leave, it counts as 5. However, I want to count the maternity leave based on the person, not the number of days. So if one person takes maternity leave in a week, it should count as 1, not 5. Thank you.

[Jihwan_Kim · Accepted solution]

Hi,

I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.

Because I do not know how your semantic model looks like, I tried to recreate a sample, and change a little bit.

I changed the weekly-question to the monthly-question, and please check the below picture and the attached pbix file.

Leave count per person: = 
VAR _t =
    ADDCOLUMNS (
        SUMMARIZE ( leave_date_fact, employee_diemnsion[name], 'calendar'[Month-Year] ),
        "@metric", 1
    )
RETURN
    SUMX ( _t, [@metric] )