Dynamic Dashboard Filter Malfunction

Last month, my dynamic dashboard filter stopped working. The filtered table showed no results when the filter itself is blank. It’s only when you have filled all criteria that a result would show up, but that has not been the effect of the formula until now. I also tried variations of the formula but they did not work either. Was there an update that affected this? Below are some of the resources I used to create the formula and the formula itself.

And(
or(isblank(Filter Table[Insurance Filter]),in([Insurance],Filter Table[Insurance Filter])),
or(isblank(Filter Table[Line Item Filter]),in([Line Item],Filter Table[Line Item Filter])),
or(isblank(Filter Table[Project Type]),in([Project Type],Filter Table[Project Type])),
or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer])),
or(isblank(Filter Table[Status]),in([Status],Filter Table[Status])),
or(isblank(Filter Table[Region]),in([Region], Filter Table[Region])),
or(isblank(Filter Table[City]),in([City],Filter Table[City]))
)

0 28 517
28 REPLIES 28
Top Labels in this Space