If you are having multiple values in the SelectedValue function or through your table relationships it ends up having a many to many relationship, you can use the following example as a way to group those values to ensure you are only getting a single value for your column.

General Use

DATEDIFF
MY_CALCULATION = DATEDIFF(Table1[Column1],CALCULATE(MIN(Table2[Column2])),HOUR)

UseRelationship

Specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2.

MY_CALCULATION = CALCULATE(SUM(InternetSales[SalesAmount]), USERELATIONSHIP(InternetSales[ShippingDate], DateTime[Date]))
  • No labels