Create Dimension from two or more Measures

[ziabobaz]

Hi, i have the following data structure

Source	SessionsCatalogView	SessionsCartView
facebook	10	12
instagram	5	4

I want to create Dimension, say [SessionViews], which would include SessionsCartView and SessionsCatalogView

Why?

I need to build a pie chart, where i can only use one dimension and one measure.

Unfortunately, I can't change the structure of the data.

Is that doable?

Thank you

[sunny_talwar]

May be use ValueList function?

[sunny_talwar · Accepted solution]

Dimension

ValueList('SessionCartView', 'SessionCatalogView')

Expression

Pick(Match(ValueList('SessionCartView', 'SessionCatalogView'), 'SessionCartView', 'SessionCatalogView'),

Expression1, Expression2)

[ziabobaz]

you are right, thank you