Forum Discussion

zskolnik's avatar
zskolnik
Frequent Visitor
6 years ago
Solved

Multiple Fact Tables

2 parter here   I have multiple fact tables and I'm looking to build a report that can pull pieces from each of them. The model looks as follows:     I don't think there are any chasm/fan ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago

    zskolnik  Yup, you'll need to get into some fun DAX expressions. 

     

    Basically, you're doing to need to use DAX to add a series of MEASURES to your data which in effect pull the information from that bottom most FACT table. 

     

    Start with this one: 

    TotalOrders = DISTINCTCOUNT(SalesOrderDetails[Order Number])
     
    Then use that TotalOrders Measure as a filter for any other calculations, such as:
    Total Accounts =
    COUNTROWS(FILTER(Account,[TotalOrders]>0))
     
     
amitchandak's avatar
amitchandak
Super User
6 years ago

zskolnik , At a high level the model seems fine, but need to check for calculation and how it there in power bi

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.