Forum Discussion

jayanthan's avatar
jayanthan
Icon for Helper III rankHelper III
8 years ago
Solved

Cumulative Totals

hi there

 

how can i show 80% of sales generated by customers/products/product group/customer group in a single chart , as X axis has above given filters

 

thank you

 

regards

Jayanthan

Need Help
Show and Tell
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi jayanthan,

     

    Please try below measures:

    Sum values = SUM('DataTable'[Value])
Total values = CALCULATE(SUM('DataTable'[Value]),ALLSELECTED('DataTable'))
percentage = [Sum values]/[Total values]

     

    Best regards,

    Yuliana Gu

3 Replies

    • jayanthan's avatar
      jayanthan
      Icon for Helper III rankHelper III
      8 years ago

      hi v-yulgu-msft

       

      i have a drilldown in my chart with customer,customergroup and product, all of them have more than 100 records,when i drilldown to customer, charts shows 100 of customers , likewise product and customer groups,

       

      therefore i want  show customers who generate 80% of the sales when i drill down to customers, customer groups who generate 80% of the sales when i drill down to customer groups

       

      Also the percentage might differ company wise, some companies has 80%, some has 60% 

       

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi jayanthan,

         

        Please try below measures:

        Sum values = SUM('DataTable'[Value])
Total values = CALCULATE(SUM('DataTable'[Value]),ALLSELECTED('DataTable'))
percentage = [Sum values]/[Total values]

         

        Best regards,

        Yuliana Gu