Iterate a condition Row by Row and then SumUp

[Krishna_Mysore]

Hi Folks

I'm struggling to write a measure which can iterate a logical condition and then summing up a column.

Basically I have a Table which Project and Resouces Data . I need to showcase the Resouces by Day with Actual time assigned and if there are any over capacity for any resourse for any given date A resourse is said to be over capacity for a day if they have been allocated more than 1 FTE per day . 

Below are my measure which works fine when shown by day , however it gives error on a summary level as the logic is not iterating through row level. 

The below measure renders correct results by Date , howerver if multiple dates are selected, it gives incorrect results as the measure is being calculated on the whole column rather than iterating at each resource and date level.

Total FTE working = if(CALCULATE(SUM('Project Data'[FTE]),CalenderTable[IsWWeekDay]<>0)>1,[FTE Available],CALCULATE(SUM('Project Data'[FTE]),CalenderTable[IsWWeekDay]<>0))

Any guidance will be much appreciated.

Thanks

Krishna

[v-piga-msft]

Hi @Krishna_Mysore ,

Sumx should help you. 

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best  Regards,

Cherry

[parry2k · Accepted solution]

@Krishna_Mysore did you looked at sumx function. There are many blogs available and here is link to one.

[Krishna_Mysore]

Thanks Parry