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

in this DAX where i can add max Funcation

 

 

مفتوح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)

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