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          50

2           1          70

2           2          70

 

When i create a diagram  and put the project id on the axis and the value as valu, it sums up the values per project. However, I only want to have one time 50 or 70 per project. Can I achieve this with a measure?

 

Thx Christian 

 

 

 

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]
)

4 Replies

  • 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]
)