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 ...
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.
Hi
I need it for a calculated column.