Forum Discussion

danmone's avatar
danmone
Frequent Visitor
6 years ago

Sales report from multiple tables

Hi 

 

Bit of a beginner on BI report writing so prob a stupid queston.  I writing a sales report that will take data from one table (G/L) and then on the next line have the quantity of the actual items shipped from a different table (Item ledger)  I can do this in 2 seperate visuals no problem, and in the same visual but here the data is on 2 different levels of hierachy.  how would I get it split into the same display taking one line at a time?

 

Thanks 

Need Help

1 Reply

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    Questions sometimes make everyone feel stupid. But 🙂 questions make you smarter, and they make the people who help you answer them smarter 🙂

    Are you looking for the quantity of items shipped for a specific line of your GL data ? If your item table has a field with an id that matches an id in your general ledger table, you can create a relationship and then write a measure that does a COUNTROWS() to count the number items that are related to a specific line in the GL table.  Post some sample data for the 2 tables if you want help with the DAX