Forum Discussion
PathContains with SelectedValue in Calculated Column or Calculated Table
Hi, everyone. I am stuggling with something. I am using the Path calculation to get a hierarchical path (e.g. A|B|C). When I reference this with a measure using PathContains and Selected Value, i...
Hi Scott,
This is the trick of context. The context of SELECTEDVALUE in a calculated column is the whole table, So it would always return blank because there isn't a single selected value. Maybe you can try it with CALCULATE. But the calculated column won't interact with the slicer or filter in the report view.
Column = CALCULATE(SELECTEDVALUE(DimProduct[BrandName], "NOT Found"))
Best Regards,
Dale
Hi Anonymous,
Could you please mark the proper answer as a solution?
Best Regards,
Dale