Forum Discussion
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 ...
mangaus1111
Solution Sage
Solution SageHi 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.
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?
Is it possible to show both?