Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Dynamic table by filter

Good afternoon; I have a problem with generating a filter to a filter according to the value entered in the primes slicer. Explain: I have a slicer where I filter the variable "Years" and I hav...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Syndicate_Admin ;

    You could create a flag measure. （ps: you should have other year table as a filter and have no relationship with main table)

    Then create a measure.

    flag = IF(MAX('Table'[year])>=MAX('filter'[Year])||MAX('Table'[year])=BLANK(),1,0)

    Then apply it into filter.

    The final output is shown below:

    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

Syndicate_Admin , first of all do not see year in all the row, That should be there. If nor then use fill up or down in power query

 

you can create a measure like

calculate(count(Table[Name]), filter(Table, Table[Year] = selectedvalue(Table[Year])))

 

use that as visual level filter for Name

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

After analyzing this option although it works, it is time to modify "the equality" of the filter to "greater or equal" and the records that do not have a date have to be filled with an extreme date.

The advantage it has is that you do not have to create a data table of years as suggested to me in the other option.