Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Helper V
5 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
    5 years ago

    Capture.PNG

    Capture.PNG

  • Greg_Deckler's avatar
    Greg_Deckler
    5 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"))
SkorpionAAM's avatar
SkorpionAAM
Helper V
5 years ago

i have survey ROund 1 and Round two

 

this is the Place digatl Id where i find the Place Dital Id if we already survey in round 1 then give me Match so we know how many we did new survey in round 2 and how many resurvy..

 

which is okay

 

biut know 2nd thing is if round 1 staion is open but now in round 2 station is close now so we need to count as a close because its latest Status of Station

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

SkorpionAAM - So like this?

Measure 6a = 
    VAR __ID = MAX([ID])
    VAR __Latest = MAX([Date])
    VAR __LatestStatus = IF(MAXX(FILTER(ALL('Table (6)'),[Date]=__Latest && [ID]=__ID),[STATUS_OF_STATION])="Open",1,0)
RETURN
    __LatestStatus

Updated PBIX attached below sig. 

  • SkorpionAAM's avatar
    SkorpionAAM
    Helper V
    5 years ago

    no ...

     

     

    as i said if round 1 Station is close and in round 2 station is open then we count round 2 one

     

    in your Dax its okay 

     

    For Example ID 1 in round 1 station was Open but In round 2 Survey Station is Closed

     

    so Wht im doing is Count how many station is close and open till date now

     

    so in round sttaion is open so now we count Close because in round 2 station is close

     

    in your Dax giving me double count  if chnage Conditon from open to close

    • SkorpionAAM's avatar
      SkorpionAAM
      Helper V
      5 years ago

      Capture.PNG

      Capture.PNG

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 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"))
      • SkorpionAAM's avatar
        SkorpionAAM
        Helper V
        5 years ago

        let me check thn i back to u