Measure with Summarize

Question

Hi,I've got a detail absence table with start and enddate and the number of sick days for that absence. In order to fnd out if the employee is LTS I've summarised the data.&nbsp;The absence table is linked to the date table on Absence End date.&nbsp;If I have an employee that starts the absence in Nov and has 17 days off and continues to be off until Mid Dec - having 10 days off. The total for the absence is 27 days and therefore the employee is considered LTS for Dec and potentiallay going forward.&nbsp;At the moment, the below is giving me 0 for LTS for both mths.&nbsp;How do I amend the code below to provide what I need?&nbsp;TIA&nbsp;&nbsp;&nbsp;Filter(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(factAbsence,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; factAbsence[EmployeeID], factAbsence[AbsenceGroupUID], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "GroupStartDate", min(factAbsence[AbsenceStartDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "GroupEndDate", max(factAbsence[AbsenceEndDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Total Sick Days", sum(factAbsence[Total Sick Days]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "LTSID", IF(SUM(factAbsence[Total Sick Days]) &gt; 20, 1 , 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Not ISBLANK([Total Sick Days]))-- Removes weekend Days start and end dates&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , [LTSID] )

greg_deckler · Accepted Answer

a_guest1005&nbsp;Sorry, having trouble following, can you post sample data as text and expected output?Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

Forum Discussion

Measure with Summarize

1 Reply

Related content

Parameter in summarize

Measure with SUMMARIZE

Don't Summarize....still summarizes...?

SUMMARIZE FUNCTION in measures

GroupBY and summarize