Unexpected characters. Characters are used in the formula in an unexpected way error?

[Usernametwice23]

Hi everyone 

I am so close to figuring this out, the syntax is just giving me an error when i try to filter down on the (views) table. I am getting the error mentioned in the heading. 

Here is the syntax I receive the error on - 

SortByColumns(Filter('Daily Measurement', Person.Name=Gallery.Selected.Person.Name),"dlg_number",Ascending), 'Daily Measurement (Views)'.'Today Active')

I  think it's the last part of the formula but I need to filter it based on these parameters because that's where the records I need are at. Any Idea how I can include 'Daily Measurement (Views)'.'Today Active')' without the error? 

Thanks and Kind regards everyone. 

[gabibalaban]

SortByColumns(
     Filter('Daily Measurement', Person.Name=Gallery.Selected.Person.Name),
     "dlg_number",
     Ascending).'Daily Measurement (Views)'.'Today Active'

[Usernametwice23]

Hi @gabibalaban Thanks for your help.

I get this error seen in the screen shot after trying this.

[timl · Accepted solution]

Hi @Usernametwice23 

If you want to apply an additional filter condition to your 'Today Active' view, I would try the following syntax:

SortByColumns(
     Filter('Daily Measurement', 
            'Daily Measurement (Views)'.'Today Active',
            Person.Name=Gallery.Selected.Person.Name
     ),
     "dlg_number",
     Ascending
)