Forum Discussion

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago
Solved

SUM for Filtered Values

Hi guys, I am definitely not a programmer, but I have to find a way out of this... I would really appreciate some help!   I have the table Cost which contains cumulative costs of production. P...
  • Anonymous's avatar
    Anonymous
    9 years ago

    CiuCiCiao,

    Create your column using the following DAX.

    Column = RELATED(Cost[Material])* Revenue[Time]/ CALCULATE(SUM(Revenue[Time]),FILTER(Revenue,Revenue[Performance]=EARLIER(Revenue[Performance])))

    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

CiuCiCiao,

Create your column using the following DAX.

Column = RELATED(Cost[Material])* Revenue[Time]/ CALCULATE(SUM(Revenue[Time]),FILTER(Revenue,Revenue[Performance]=EARLIER(Revenue[Performance])))

Regards,

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago

Thanks a lot is working perfectly, now I just have to understand why :manvery-happy:

Thanks Again!