Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Substitute Value in Filter

I have a simple measure that counts the number of enrollments for three unique periods, Fall, Spring and Summer. Using SelectedValue I can tell what priod has been requested and only want to return...

DAX code

tamerj1
3 years ago
Hi Anonymous

manually create 'Terms' a disconnected single column table that contains fall, spring, summer

in the measure define the variable

VAR _term = SELECTEDVALUE ( Terms[Term] )

Anonymous

Not applicable

3 years ago

tamerj1,

Thank you very much for your quick reply,

I made a quick test and am still having an issue.

Here are the steps I have taken.

Made a quick Term table which looks like this

Added the following selection statement, which returns “Fall” VAR _term = SELECTEDVALUE(FallTerm[Term])
Add _term to filter statement and there was no return of column data.

Removed the quotations and there was no return of column data.

Hard coded “Fall” in filter statement and column data is returned.

I have to assume the only two items that are causing the problem is that created the Term table incorrectly, or something else needs to done to handle the quotation marks.

I really appreciate your time with this issue, it appears to be a simple problem , unfortunately I have not been able to find the answer,

Pjb120

tamerj1