Forum Discussion
Anonymous
1 year agoNot applicable
Divide Column By Column
Hi, Is there a way to divide the count of bar marks per slice (i.e. 3 E12 for Slice S002) by the count of slices in a segment (i.e. 3 S002 for segment 01N)? The results for column S002 and row...
bhanu_gautam
1 year agoSuper User
Anonymous Create a measure to count bar marks per slice:
BarMarksPerSlice = COUNTROWS('YourTable')
Create a measure to count slices in a segment:
SlicesInSegment = CALCULATE(
DISTINCTCOUNT('YourTable'[SliceColumn]),
ALLEXCEPT('YourTable', 'YourTable'[SegmentColumn])
)
Create a measure to divide the count of bar marks per slice by the count of slices in a segment:
Result = DIVIDE([BarMarksPerSlice], [SlicesInSegment])