Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

TREATAS returns blanks where it should not.

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

1 REPLY 1
Anonymous
Not applicable

Nothing can be said without actually giving access to the file or a file that demonstrates your issue.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors