Forum Discussion

FabianTWCM's avatar
FabianTWCM
New Member
8 years ago

How to sum rows evaluating values

 

Hi All,

 

I would like to ask for your advice. I am trying to sum the values of one column evaluating three different condicitons.

 

I treid to sort it out, using using -managing relationships- but a error about 'ambiguous' appeared.

 

Based on this, I have tried to sum the values across one column, evaluating three conditions: Store, Vendor and date. This information is is in he same table and each row contains these patameters. And later, I will try to connected it to a differen table, to breakdown these information by store, vendor and date.

 

Thank you in advance.

Need Help

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi FabianTWCM,

     

    Based on your description, I made an sample here. My original table looks like this. And I Enter another three tables that contains unique values of Store Vendor and date.

     

     

    And I create relationship between tables like this. And I create threecalculated columns in Store, vendor and date table separately using the formulas as below.

     

    SALESS = CALCULATE(SUM(Table1[SALES]))
    SALESV = CALCULATE(SUM(Table1[SALES]))

     

    saled = CALCULATE(SUM(Table1[SALES]))

     

     

     

     

     

    Then we can get the result as we excepted.

     

     

     

    For more details, please check the pbix as attached. If it doesn't meet your requirememt, kindly share your sample data and excepted result to me.

     

    https://www.dropbox.com/s/m3tzfxw8a2qiur3/How%20to%20sum%20%20rows%20evaluating%20values.pbix?dl=0

     

    Regards,

    Frank

     

     

    • FabianTWCM's avatar
      FabianTWCM
      New Member
      8 years ago

      Hi Frank,

       

      Thank yuo vey much for your time. Please, can you share with me ,an e-amil address in order to share this file through wetransfer. On it, you will be able to see:

       

      I have tried to create a create a relation among the tables. here, in this scenario is where "ambiguous path". The reason could be, I am trying to use: Vendor, store and date as link

       

      On the tab, -TableExample-, I am trying to bring the information from Patiente Table to the HealthApp table, but it shows a different total 

       

      Thank you

    • FabianTWCM's avatar
      FabianTWCM
      New Member
      8 years ago

      Hi Frank,

       

      Below I have included some screenshots to show you the nature of this file.

       

      This is the relation diagram, when I tried to to use the date as an another Table.

       

      Below thr table where, I ma trying to connect the data using: Store, Vendor and date fields.

       

      I am new using this platform. I did not find the option to attached the file. But you can find the imaes above. let me know if it is clear.

       

      Thank you