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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

OK, so what I did was create your queries in an example. I related Sales Orders (Query 1) and Sales Quantities (Query 3) on Sales Order. Then I created a matrix with Sales Order from Sales Order table, Item from Sales Quantities table and Sales from Sales Quantities table, seemed to work swell. Let me know if you want me to post some screen shots.

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