Forum Discussion

prinsniels's avatar
prinsniels
New Member
9 years ago
Solved

Count based on 2 columns in table

Hi,   Hope someone can help   I have 2 tables; 1. Table1 holding dates 2. Table2 holding orders   I want to visualize the amount of open orders through time. Meaning,   Table 2 holds three ...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Create a measure (or calculated column in Dates table): like this:

     

    OrderCount = CALCULATE(COUNT(Orders[OrderNo]),FILTER(RELATEDTABLE(Orders),Orders[StartDate]<='Calendar'[Date] && Orders[EndDate]>='Calendar'[Date]))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Create a measure (or calculated column in Dates table): like this:

 

OrderCount = CALCULATE(COUNT(Orders[OrderNo]),FILTER(RELATEDTABLE(Orders),Orders[StartDate]<='Calendar'[Date] && Orders[EndDate]>='Calendar'[Date]))