Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |