Hello,
I am using TREATAS to return a text field in a measure where I'm not able to join the tables directly due to circular referencing with RLS.
However, although it is returning a lot of values, it is also returning some blank rows where I would expect data to be returned, does anyone know why this may be?
I started using one field to join on:
VAR _id = CALCULATETABLE( VALUES( report_pm_change[asset_unique_id] ))
RETURN
CALCULATE (
SELECTEDVALUE(report_asset_change[status]),
TREATAS( _id, report_asset_change[asset_unique_id] )
)
However when this did not work, I tried to join on two fields with the same inconsistent result:
VAR _id = SUMMARIZE( report_pm_change, report_pm_change[asset_unique_id], report_pm_change[asset_number] )
RETURN
CALCULATE (
SELECTEDVALUE(report_asset_change[status]),
TREATAS(_id, report_asset_change[asset_unique_id],report_asset_change[reference] )
)
Any input would be welcome.
Thanks,
Mark
