Forum Discussion

Dankang's avatar
Dankang
Regular Visitor
7 years ago
Solved

simple dax question

 

Hi All,

 

Hope anyone can help me with this.

 

I am trying to get Total number of O&A Display for only the highest callfilevisit ID for Each outlet. 

 

i.e outlet "1000245" will only need to show a value of 2 from callfilevisit ID "28232875" and so on, then sum all the values.

 

I have tried Max function but it only brings max callfilevisit ID for all outlets.

 

Any advice or help would be greatly appreciated.

Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    try this code

    Measure =
VAR OutletsVisits =
    GROUPBY (
        'Table',
        'Table'[OutletId],
        "Callfilevisit ID", MAXX ( CURRENTGROUP (), [Callfilevisit ID] )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Total O&A Displays] ),
        TREATAS ( OutletsVisits, 'Table'[OutletId], 'Table'[Callfilevisit ID] )
    )

    it gets the max callfilevisit per outlet and then calculates the sum of displays for these entries

3 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    try this code

    Measure =
VAR OutletsVisits =
    GROUPBY (
        'Table',
        'Table'[OutletId],
        "Callfilevisit ID", MAXX ( CURRENTGROUP (), [Callfilevisit ID] )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Total O&A Displays] ),
        TREATAS ( OutletsVisits, 'Table'[OutletId], 'Table'[Callfilevisit ID] )
    )

    it gets the max callfilevisit per outlet and then calculates the sum of displays for these entries