topic Re: Is it possible? Creating a relationship between a measure and a cell of a column (of a table) in DAX Commands and Tips

Is it possible? Creating a relationship between a measure and a cell of a column (of a table)

Anonymous — Thu, 08 Sep 2022 12:04:10 GMT

Hello community,

Is there any way to set up a relationship between a measure and a Column of a table?

So what I thought is the following:

1) I created a new table with the GENERATESERIES() Function. In this function I just put in a span of integers (For example 1 until 10)

2) I created 10 measures for every integer value.

3) Usually I just can create relationships between tables. But now I would like to have a 2-Tuple.

4) I considered to do something like this / the idea: { (1, measure_result_1), (2, measure_result_2), ..., (10, measure_result_10) }

5) Result should be a visualisation with 1 until 10 on x-axis and the corresponding results on the y-axis.

Thanks in advance

Re: Is it possible? Creating a relationship between a measure and a cell of a column (of a table)

Greg_Deckler — Thu, 08 Sep 2022 12:09:20 GMT

Anonymous Maybe:

Measure = SWITCH('Table'[Index], 1, [measure1], 2, [measure2], 3, [measure3], 4, [measure4], ... )

Re: Is it possible? Creating a relationship between a measure and a cell of a column (of a table)

Jihwan_Kim — Thu, 08 Sep 2022 12:17:18 GMT

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below, and I hope the below can provide some ideas on how to create a solution for your dataset.

Expected result measure: = SWITCH ( TRUE (), SELECTEDVALUE ( 'Axis table'[Value] ) = 1, CALCULATE ( SUM ( Data[Quantity] ), Data[Category] = "Ca01" ), SELECTEDVALUE ( 'Axis table'[Value] ) = 2, CALCULATE ( SUM ( Data[Quantity] ), Data[Category] = "Ca03" ), SELECTEDVALUE ( 'Axis table'[Value] ) = 3, CALCULATE ( SUM ( Data[Quantity] ), Data[Category] = "Ca08" ) )