Calculate Table with Selected Value

[vstoppPCM]

What am I doing wrong?  I do not get an error, but get 0 rows in my calculated table.  If I type in the facility name (In place of SelectedFacility) manually enclosed in quotes, it works fine.  Using selected values returns 0 rows.  Please Help.

TimelineFiltered =

Var SelectedFacility = SELECTEDVALUE(CostUtilization[FAC_FacilityName]) RETURN

CALCULATETABLE(CostUtilization_TimeLine, CostUtilization_TimeLine[timeFacility] = SelectedFacility)

[amitchandak]

@vstoppPCM , You can create a table, but it will not change based slicer value.

[parry2k]

@vstoppPCM the underline question is why you need a calculated table? What problem you are trying to solve? As @amitchandak mentioned, you cannot use slicer values in a calculated table expression.

Explain the problem and I'm sure someone will assist.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡