Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with filters

Hello, I have a problem with a filter in a calendar table and I am not being able to figure out what I am doing wrong. The issue seems simple, but the filter expression that I am using doesn´t work t...
  • DavisBI's avatar
    DavisBI
    5 years ago

    Hi, Anonymous ,

     

     If you look at the screenshots I provided, your requirements have been met. But I may need to add that slicers are not related to the main table, you can test it again.

     

    Best!

     

    Mark this post as solution if this helps,thanks!

DavisBI's avatar
DavisBI
Icon for Solution Specialist rankSolution Specialist
5 years ago

Hi, Anonymous ,

In this case you can use selectedvalue() . The following is for your reference:

 

Measure = EOMONTH(DATE(<year>,SELECTEDVALUE('Table'[Value]),1),0)

 

 

Mark this post as solution if this helps,thanks!