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!!