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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sanju24
Frequent Visitor

TreatAs Giving Wrong Result

sanju24_0-1676273816630.png

Hello,
I want to build a relationship between two Tables using Name Column using TreatAs . Although it is not giving expected results when I use Name column with the measure.

2 REPLIES 2
amitchandak
Super User
Super User

@sanju24 , Add additional

 

values('Payment-Grid View'[Name]) , after treatas

 

 

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.