cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Iterate a condition Row by Row and then SumUp

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Iterate a condition Row by Row and then SumUp

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

Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.

3 REPLIES 3
Super User

## Re: Iterate a condition Row by Row and then SumUp

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

Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.

Community Support Team

## Re: Iterate a condition Row by Row and then SumUp

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

Thanks Parry