Aggregate data entity

[ngyonghan]

Hi guys,

I need a help on PowerBI desktop, looking at 2 ADE can't be join together on field.

May I know the possible causes of this stopping message?

Thank you in advance

[ankitpatira]

@ngyonghan as error itself suggests your table Sales analysis has values that are missing in Measure type table. Ensure all values in measure type column in sales analysis table is present in Measure type column.

[ngyonghan]

Both is been generated from aggregate measure, its been pulled from DataWarehouse.

What I can see is the MeasureType dim does have unusual rows of record.

MeasureType (Dimension)

Sales analysis (Fact table)

[ankitpatira]

@ngyonghan dimension table having more than one value is ok. in your relationship editor ensure you choose cardinality properly ie dimension table (Many) to fact table (One) and cross filter direction to single.

[ngyonghan]

@ankitpatira Thank you for your help