Forum Discussion

bumoverflow's avatar
bumoverflow
Frequent Visitor
3 years ago

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

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

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.

No RepliesBe the first to reply