Forum Discussion

rai024's avatar
rai024
Frequent Visitor
2 years ago
Solved

Adding a filter after removing filter context on the same column

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 usin...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    2 years ago

    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
    )

     

rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

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
)

 

  • rai024's avatar
    rai024
    Frequent Visitor
    2 years ago

    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.

    • rubayatyasmin's avatar
      rubayatyasmin
      Community Champion
      2 years ago

      rai024 if my answer helped you then accept my answer as a solution. So that the thread is marked as completed. 

       

      Thanks.