Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Icon for Helper V rankHelper V
6 years ago
Solved

Max Calculation

New to DAX here. I am trying to calculate the latest record  i create the new column which  if place_digital_adress is same then Match if not then Not match _LOOK = var _val = LOOKUPVALUE('GasSt...
Need Help
Show and Tell
Tips and Tricks
  • SkorpionAAM's avatar
    SkorpionAAM
    6 years ago

    Capture.PNG

    Capture.PNG

  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    @SkorpionAAM So, this? PBIX attached.

    Measure 6b = 
    VAR __Table =
    ADDCOLUMNS(
        SUMMARIZE('Table (6)',[ID],"Date",MAX([Date])),
        "Status",MAXX(FILTER('Table (6)',[ID]=EARLIER([ID])&&[Date]=EARLIER([Date])),[STATUS_OF_STATION])
    )
RETURN
    COUNTROWS(FILTER(__Table,[Status]="Open"))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

SkorpionAAM Which one? Both suggestions? What is the expected output from the sample data?

  • SkorpionAAM's avatar
    SkorpionAAM
    Icon for Helper V rankHelper V
    6 years ago

    i need to count as well with this Method

    مفتوح1 = var openx = CALCULATE(COUNT('GasStation Survey'[_LOOK]),FILTER('GasStation Survey','GasStation Survey'[_LOOK] = "Not Match"),FILTER('GasStation Survey','GasStation Survey'[survey_round_id] = "Round 2"),FILTER('GasStation Survey','GasStation Survey'[STATUS_OF_STATION] = "Open")
    ) return
    IF(ISBLANK(openx),0,openx)

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      SkorpionAAM . Can you share expected output? If the initial one output then share source.