Direct Query, simple unit conversion scenario

[donquijote]

I have a very simple unit conversion problem that I haven't been able to solve in a Direct Query dashboard.

Table 1: Has 2 columns, date and value.

I would like to be able to display the value column in different units, selected by the user (for example via slicer?)

I created Table 2 with two columns: UnitName and ConversionFactor

The value I want to be able to display in my visuals is Table1[value] * Table2[ConversionFactor]

However given there is no relationship between the tables i cannot use RELATED to do this calculation and so far I haven't found an alternative.

Open to other ways to achieve this result in DirectQuery.

Thanks

[donquijote · Accepted solution]

This can be solved using a simple calculated measure:

MyMeasure = AVERAGE(Table1[Value]) * AVERAGE([Table2[ConversionFactor]])

When user selects the Table2[UnitName] in the slicer, the visualization of MyMeasure against Table1[Date] updates the converted value correctly in Direct Query.