Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to do the sub total

Hi Experts,   I have data and i can calculate the numbers basbed on the criteria (i.e) Item number which is already existing in my data table.   Here I want to insert one addition item number for...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

Currently, the total/subtotal value is generated automatically by power bi. I'm afraid you need to create a measure manually using dax code to achieve your requirement.

 

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

     

     

     

     

     

     

     

     

    Yes, know that option, but i want to acheive the result shown as above.

     

    Item number 40 and 90 are not in the data table, if I want to get that should I create a measure or calculated column? if yes how to insert that line in between the item numbers?

     

    Regards,

    Swamy