Forum Discussion

Batman_powerbi's avatar
Batman_powerbi
Frequent Visitor
2 years ago
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...
Need Help
Batman_powerbi's avatar
Batman_powerbi
Frequent Visitor
2 years ago

thanks bhanu_gautam 

unfortunately i get a duplication of the count of each time the Project is listed in the data table 



the true nature of the output should be like below,

 

 

 

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Update measure
Count of Categories =
CALCULATE(
COUNTROWS('Closed (TABLE)'),
ALLEXCEPT('Closed (TABLE)', 'Closed (TABLE)'[Difference Category])
)

  • Batman_powerbi's avatar
    Batman_powerbi
    Frequent Visitor
    2 years ago

    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