RELATED doesn't work in Many-to-One relationship in Power Pivot

[Aidan_Wang]

Hi

I'm using Power Pivot in Excel with a many-to-one relationship. I want to get data from the one side to the many side. I trie calculated column and measure to do so but all failed. The calculated column returned blank and the measure showed error.

DAX for the calculated column and measure are the same as below.

=RELATED('BH_Capacity_Standard'[Max SKU Capacity])

I remembered I have used similar measure in Power BI and I think there's no big difference between Power BI and Power Pivot about DAX.

Thanks in advance!

[tamerj1]

Hi @Aidan_Wang 

RELATED works just fine in Power Pivot

check your data. The data type of the columns involved in the relationship should match. An extra space or hidden character will cause a problem. First of all double check that the relationship is built over the correct columns.