Forum Discussion

MSuser5's avatar
MSuser5
Icon for Helper III rankHelper III
3 years ago
Solved

Sub unit Total

Hi All,   I have data sub unit and each month and i'm created category within/ Beyond SLA level now i want to calculate Total of sub unit level   kindly hlep me on this.   Sub_Unit Count V...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello MSuser5 ,

     

    Try using following DAX:

    ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])
     
    Thanks
    If this helps, mark this as a solution!!
  • Dhairya's avatar
    Dhairya
    3 years ago

    Heu MSuser5 

    Input:


    Please create the following measure

     

    Sub_unit Total = CALCULATE(SUM(TableA[Count]), ALLEXCEPT(TableA,TableA[Sub_Unit]))

    And Plot the table and you will get the expected output:

     

    If this helps you then please mark my solution as accepted so that others can find it quickly when they face the similar issue. Thank you!

Dhairya's avatar
Dhairya
Icon for Solution Supplier rankSolution Supplier
3 years ago

Heu MSuser5 

Input:


Please create the following measure

 

Sub_unit Total = CALCULATE(SUM(TableA[Count]), ALLEXCEPT(TableA,TableA[Sub_Unit]))

And Plot the table and you will get the expected output:

 

If this helps you then please mark my solution as accepted so that others can find it quickly when they face the similar issue. Thank you!

  • MSuser5's avatar
    MSuser5
    Icon for Helper III rankHelper III
    3 years ago

    Thanks its working as expected