Forum Discussion

Anna123456's avatar
Anna123456
Frequent Visitor
3 years ago
Solved

Get column based on date and title

Hello,  I have a question. I want to get the value of "visit24hrs" for today for each title in my report. I try to use this formula:    result = CALCULATE(SUM(AnalyticsView[Visits24h]), FILTER(A...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anna123456 

    are you expecting something like:

    result = 
MAXX(
    FILTER(
        ALL(AnalyticsView), 
        AnalyticsView[Date] = TODAY()
    ),
    AnalyticsView[Visits24h]
)
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anna123456 

are you expecting something like:

result = 
MAXX(
    FILTER(
        ALL(AnalyticsView), 
        AnalyticsView[Date] = TODAY()
    ),
    AnalyticsView[Visits24h]
)
  • Anna123456's avatar
    Anna123456
    Frequent Visitor
    3 years ago

    I added another filter (for the distinct items) and now it works with your code. thank you!! 

  • Anna123456's avatar
    Anna123456
    Frequent Visitor
    3 years ago

    Hello, 

     

    Now I get the max value of my visits24hr over all items ... so in my chart it is displaying the same number for every item (which is not correct....)
    But thank you for your try to help me 🙂