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!

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

Hi, MSuser5 

 

From the picture, I get that you have three columns right? and last column has text and number mixed and you want to sum the numbers. 

 

here is the suggestation. 

1. go to power query.

2. split the last column

 

 

here is the documentation for you. https://learn.microsoft.com/en-us/power-query/split-columns-delimiter 

after split, you will have 2 columns. rename with your own choise. 

 

sum it up or visualize it in a table.