Forum Discussion

Libin7963's avatar
Libin7963
Icon for Helper II rankHelper II
2 years ago
Solved

Help required for DAX FUNCTION

In the below meaure the bolded part doesn't filter or make any difference to the outcome.  when I apply the same filter in filter pane it works.   SelectedStartDate = FIRSTDATE(DateTable[Date]) and...
DAX
power bi
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Libin7963 Try simplifying this and this is my best guess as to the logic you are going for.

    Measure =
  VAR __Table = 
    FILTER( 
      'TABLE1',
      [Type] IN { "A", "B", "C", "D", "E", "F", "G", "H", "I" } &&
      ( 
        ISBLANK([DECISIONDATE]) || 
        [DECISIONDATE] >= [SelectedStarteDate] && [VALIDDATE]] < [SelectedStartDate]
      )
    )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Libin7963 Try simplifying this and this is my best guess as to the logic you are going for.

Measure =
  VAR __Table = 
    FILTER( 
      'TABLE1',
      [Type] IN { "A", "B", "C", "D", "E", "F", "G", "H", "I" } &&
      ( 
        ISBLANK([DECISIONDATE]) || 
        [DECISIONDATE] >= [SelectedStarteDate] && [VALIDDATE]] < [SelectedStartDate]
      )
    )
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result