• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Treat As in Power BI

I

Ipshitha

New Member
Hi,

I have a clients table which have one to many connection with the Departments table and the Clients table also have one to many connection with the Plans table.

When Iam trying to get the data into a Table visual from all the three tables, it's not working as the relationship should be many to many.

How to solve this using TreatAs by creating the virtual relationships.

Thanks
 
Have a read of below article.
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
Many-to-many relationship guidance - Power BI | Microsoft Docs

You need to transform and/or normalize data into fact and dimension tables. But depending on data and relationship, it may require you to denormalize fact and one of the dimensions.

TreatAs isn't ideal use here. As it's best suited for two tables that are not related, but have columns that share same attribute (i.e. when filtering one table's category column using another table's category column).

From your description. This isn't the case here.
 
Last edited:
You must log in or register to reply here.
Back
Top