Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

 

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

3 Replies

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Parry

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi Anonymous ,

    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