Forum Discussion

damj's avatar
damj
Frequent Visitor
3 years ago

Find distinct sum from filtered column

Hi i am trying to get a sum from the distinct values in each level.

Level4 contains

F&R Øst
F&R Vest

Level5 contains 

Indbygning
Eftersyn IC4
Infrastruktur Vest
Lærlinge
St. eftersyn IC3
Eftersyn IC3
Reparationer IC4

for each of these i want the sum, which i tried to illustrate underneath.

 

Hope someone can help with my problem.

 

 

Need Help
Tips and Tricks

6 Replies

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi damj ,

    measure or calculated column?

    If you need a measure I think that you can use this one:

    CALCULATE(

                    SUM('Table'[Employes]),

                   ALL('Table'[Level5])

    )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • damj's avatar
      damj
      Frequent Visitor
      3 years ago

      Hi
      I need it for a calculated column.

       

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi damj ,

    you can use this

    Column = 
SUMX(
    FILTER(
        'Facts2',
        'Facts2'[Date] = EARLIER('Facts2'[Date]) && 'Facts2'[Level4] = EARLIER('Facts2'[Level4])
    ),
'Facts2'[Employes]
)

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • damj's avatar
      damj
      Frequent Visitor
      3 years ago

      is it possible to do for Month and find the distinct value for level 5 and sum it together for level 4?