Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 those entries. My measure is as follows and I would like to substitute the term variabale (Fall, Spring or Summer) in the FIlter line.
I have have no sucesss, if you enter "Fall" it works great, so I need a method to have Quotiations in the substution,
CALCULATE(COUNTROWS(Enrollment),
Amy and all suggestions willbe greatly appreciated.
Solved! Go to Solution.
Hi @pjb120
manually create 'Terms' a disconnected single column table that contains fall, spring, summer
in the measure define the variable
VAR _term = SELECTEDVALUE ( Terms[Term] )
Hi @pjb120
manually create 'Terms' a disconnected single column table that contains fall, spring, summer
in the measure define the variable
VAR _term = SELECTEDVALUE ( Terms[Term] )
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |