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!

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

Hi rubayatyasmin ,

 

Sub_unit Total -  i need to create in measure

rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

so, you can not split the column? it is your requirement?