Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
is it possible to do for Month and find the distinct value for level 5 and sum it together for level 4?
Is it ok a measure?
Is it possible to show both?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |