Forum Discussion
Solved
Categorise Plus or Minus %
Hi Team below is sample data of what i am calculating against So far i am able to roll up the calculations whether by function or project and obtain a % difference between estimates/Act...
Hi,
You can solve this with segmentation. I have solved a similar problem in the attached file.
Hope this helps.
Update measure
Count of Categories =
CALCULATE(
COUNTROWS('Closed (TABLE)'),
ALLEXCEPT('Closed (TABLE)', 'Closed (TABLE)'[Difference Category])
)
bhanu_gautam
sorry again that is still giving me a duplicate of counts
i believe its due to the initial calculated column instead of being a measure
- as a column the calculation then assigns a calculation to every row in the table, rather than a rolled up level by project/function