Forum Discussion

_chris_'s avatar
_chris_
Helper III
7 years ago
Solved

DAX question

Hi,   i have a dataset with some columns whereas my problem is only with the following ones:   projectid   operation  value 1           1          50 1           2          50 1           3   ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I think that you can use this, if I understand this correctly 

    Remainder = 
SUMX(
    SUMMARIZE(
        Table,
        Table[project],
        Table[engineer],
        "Remainder",AVERAGE(Table[remainder(project)])
    ),
    [Remainder]
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Instead of SUM you can use MAX, MIN, AVERAGE, etc. if the value is always the same for the project. I.e.
Function Name = MAX(Table[value]).

 

Regards,

Kristjan

  • _chris_'s avatar
    _chris_
    Helper III
    7 years ago

    Thx, however, i am afraid my question was not good enough

     

    project  operation engineer remainder(project)

    1        1         a         10

    1        2         a         10

    2        1         a          5

    2        2         a          5

    3        1         b         20

    3        1         b         20

     

    I want to see the remainng work per engineer in a diagram => a=10+5, b=20

    Sorry for not having asked the right question in the fiirst go.

     

    BR Chris

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I think that you can use this, if I understand this correctly 

      Remainder = 
SUMX(
    SUMMARIZE(
        Table,
        Table[project],
        Table[engineer],
        "Remainder",AVERAGE(Table[remainder(project)])
    ),
    [Remainder]
)
    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      _chris_

      Ok, but what is the rationale for choosing 10+5 and not 10+5+10+5 for a?

      Is it one value per project?  Otherwise, what?