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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Syndicate_Admin ;

So I would like to know whether my method has solved your problem? If not, can you provide more details?


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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

I don't understand the question. since your option was the one I chose as a solution.