Forum Discussion

vstoppPCM's avatar
vstoppPCM
Frequent Visitor
6 years ago

Calculate Table with Selected Value

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)
Need Help

2 Replies

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      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.⚡