Forum Discussion

vikrammankar's avatar
vikrammankar
Frequent Visitor
4 years ago
Solved

How to calculate Sales%

Hi,   I have below table for Sales with three columns, Month, Country & Sales_Amt.  I want to create two measures Total_Sales (Sum of all rows in the table) & Sales%. Can somebody help me with thi...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi vikrammankar ,

     

    Add the following two measures:

    Total Sales = CALCULATE(SUM('Table'[Sales_Amt]), ALL('Table'[Country],'Table'[Month]))


% sales = DIVIDE(SUM('Table'[Sales_Amt]), 'Table'[Total Sales])

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi vikrammankar ,

 

Add the following two measures:

Total Sales = CALCULATE(SUM('Table'[Sales_Amt]), ALL('Table'[Country],'Table'[Month]))


% sales = DIVIDE(SUM('Table'[Sales_Amt]), 'Table'[Total Sales])

 

 

vikrammankar's avatar
vikrammankar
Frequent Visitor
4 years ago

Thanks a lot man.  That helped. 😊😊