Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

calculate sum based on another column distinct values

Hi Team,

     how to find sum using another column distinct values, after unpivoting the the columns im getting results like this

 

i want to sum of Total column,    i need result is 3.7  but im getting 11.1

calculate the sum based on another column distinct values  How to solve this?

 

 

 

Thanks,

Ranga

 

 

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous    it's work but i need other column to build the table

     

    i'm looking measure only i have used below measure

     

    Total sales = SUMX(DISTINCT('Table'[Category]),MAX('Table'[Total]))
     
    it's work for me
     
    Thanks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I think what you want can be done in Power Query - Transform - Group by.

     

     


    When I do that I get the results you seek: 

     

     

    I used these settings for the step:

     

     

    Let me know if it works

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous    it's work but i need other column to build the table

       

      i'm looking measure only i have used below measure

       

      Total sales = SUMX(DISTINCT('Table'[Category]),MAX('Table'[Total]))
       
      it's work for me
       
      Thanks