Forum Discussion

Ryks's avatar
Ryks
Frequent Visitor
5 years ago
Solved

Dax - Filter by 2 date columns - Metric

Hi   I hope somebody can help me. Question: How many order were open per month. I have a date table - Calendar(Date) that has an active relationship with Open.     Data set ID Open Close...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Ryks 

    you can modify the measure by adding ALL function

    Measure = 
CALCULATE(COUNTROWS('Table'),FILTER(all('Table'),('Table'[Close]>max('Date'[Date])||ISBLANK('Table'[Close]))&&'Table'[Open]<max('Date'[Date])))

    pls see the attachment below

     

  • Ryks's avatar
    Ryks
    5 years ago

    Excellent.

    Thank you ryan_mayu 

Ryks's avatar
Ryks
Frequent Visitor
5 years ago

Hi Greg_Deckler 

Great solution. 

I however, have relationships on my table.

Active - Open to Calendar Date and inactive with Close.