cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anna123456
Frequent Visitor

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(ALL( AnalyticsView), (today() = AnalyticsView[Date]))) 

In my chart I use for Y Title and for X result.
But now I get the same number (the summed result) for each Title. 
Question: How can I display the result for each item in my chart? Without the "sum" in the formula I am not able to use Visits24hrs in the measure (it says it can not regognize the column)
 
Best wishes, 
Anna
1 ACCEPTED SOLUTION
FreemanZ
Community Champion
Community Champion

hi @Anna123456 

are you expecting something like:

result = 
MAXX(
    FILTER(
        ALL(AnalyticsView), 
        AnalyticsView[Date] = TODAY()
    ),
    AnalyticsView[Visits24h]
)

View solution in original post

4 REPLIES 4
andhiii079845
Solution Sage
Solution Sage

You use this as a calculated column, right?

result = CALCULATE(SUM(AnalyticsView[Visits24h]), FILTER(ALL( AnalyticsView), (today() = AnalyticsView[Date]))) 
FreemanZ
Community Champion
Community Champion

hi @Anna123456 

are you expecting something like:

result = 
MAXX(
    FILTER(
        ALL(AnalyticsView), 
        AnalyticsView[Date] = TODAY()
    ),
    AnalyticsView[Visits24h]
)

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

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 🙂 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors