Find distinct sum from filtered column

[damj]

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.

[mangaus1111]

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]

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

[mangaus1111]

Is it ok a measure?

[damj]

Is it possible to show both? 

[mangaus1111]

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]

Hi
I need it for a calculated column.