topic Re: Values in table disappear after adding new column from a related table in DAX Commands and Tips

Values in table disappear after adding new column from a related table

Anonymous — Mon, 08 Jul 2024 08:41:55 GMT

I have a table with Course, Duration, and the teacher assigned.

Course and Duration are in the same table and the teacher name is in another table, related with a bridge table.

This is the table with all the Courses and Durations.

But when adding the teacher:

The others disappear.

Any ideas?

Re: Values in table disappear after adding new column from a related table

foodd — Mon, 08 Jul 2024 08:45:02 GMT

Hello Anonymous , and thank you for sharing a question with the Community. The following reply is informational. Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: Values in table disappear after adding new column from a related table

Anonymous — Mon, 08 Jul 2024 08:56:12 GMT

The data I'm working with is confidential so I can't share any files. I can provide screenshots and blur anything sensitive

Re: Values in table disappear after adding new column from a related table

foodd — Mon, 08 Jul 2024 09:09:04 GMT

Hello Anonymous. You can prepare both a sample source file and PBIX using fictitious data while preserving the model, report, and any DAX measures present. This is quite common and is the practice here as well as in several other well-known venues.