Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am using Azure maps to show 3d columns on given latitudes and longitudes. I have a table that contains latitude, longitude, date,hour and value. I am showing value as a 3d column. I am using a slicer to select dates to see the data for only selected dates. I am also using the play axis to animate the value by hour. I have another requirement when I hover over a particular location (latitude and longitude) then I should be able to see the last 7 days of data from the latest date as tool tip, irrespective of the dates selected. I am implementing this using a measure with the following DAX formula.
Thanks
Ayush
Solved! Go to Solution.
Hi, @rai024
will it be SUM('MIN_1069 (2)'[Value]) or SUM('MIN_1069'[Value])?
Also use this revised DAX see if it helps.
SelectedValue =
VAR MaxDate = CALCULATE(MAX(MIN_1069[Value.Date]), ALL(MIN_1069))
RETURN
CALCULATE(
SUM(MIN_1069[Value]),
ALL(MIN_1069[Value.Date]), -- remove any filter on the date column
MIN_1069[Value.Date] >= MaxDate - 6,
MIN_1069[Value.Date] <= MaxDate
)
Proud to be a Super User!
Hi, @rai024
will it be SUM('MIN_1069 (2)'[Value]) or SUM('MIN_1069'[Value])?
Also use this revised DAX see if it helps.
SelectedValue =
VAR MaxDate = CALCULATE(MAX(MIN_1069[Value.Date]), ALL(MIN_1069))
RETURN
CALCULATE(
SUM(MIN_1069[Value]),
ALL(MIN_1069[Value.Date]), -- remove any filter on the date column
MIN_1069[Value.Date] >= MaxDate - 6,
MIN_1069[Value.Date] <= MaxDate
)
Proud to be a Super User!
Worked almost. I wanted the largest selected date so I removed the All from the variable and it worked. Thank you. I have been at this for a couple of days.
@rai024 if my answer helped you then accept my answer as a solution. So that the thread is marked as completed.
Thanks.
Proud to be a Super User!
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |