Forum Discussion

SCPowerBI's avatar
SCPowerBI
Regular Visitor
9 years ago

Linking Tables One to Many - Cumulative Value Issues

Hi All,     I have two queries that I have linked as a 1 to many ratio by Sales Order # as the unique identifier.   Query 1 - Has sales order for each individual row without "sales value"$ amoun...
Need Help
SCPowerBI's avatar
SCPowerBI
Regular Visitor
9 years ago

Yes I would appreciate it, I have searched for info on merging the queries. I need something similar to a sum-if in excel basically sum if sales order, item.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi SCPowerBI,

I create a Matrix visual and Card visual using your sample data, does the following screenshot display your expected result?




When I filter item to A, the two visuals return correct values as follows. For more details, please check the attached PBIX file.




Thanks,
Lydia Zhang