Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |