cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Krishna_Mysore Regular Visitor
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
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.





Did I answer your question? Mark my post as a solution!


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
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.





Did I answer your question? Mark my post as a solution!


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




 




Community Support Team
Community Support Team

Re: Iterate a condition Row by Row and then SumUp

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

 

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.
Krishna_Mysore Regular Visitor
Regular Visitor

Re: Iterate a condition Row by Row and then SumUp

Thanks Parry