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...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity 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