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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bumoverflow
Frequent Visitor

Dimension result based on fact

Hello all

I encountered a problem that seems to be really bizzare.

I ahve a fact table and dimension table

bumoverflow_0-1684226995913.png

I insert in one table visualization id from fact table and I want to add customer_name as well. What happens is that I'm getting the same result for all rows

bumoverflow_1-1684227106671.png

First two columns come from fact table, the last one is from dimension (customer) table. I want to use customer to get name of customer but in order to do that I need Power BI to automatically assign proper values.

I already tried phew DAX solutions with selectedvalue function but non of them worked so far.

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors