Entering measures in column

[VViskaz]

Hello,

I have a custom table that has indicator names in it and i need to put multiple measures from top to bottom next to it. Is it possible?

"Result" column is where I need to put my measures in. 

[Fowmy · Accepted solution]

@VViskaz 

Try:

Result =

SWITCH([Column1],

"Solution Quality", [Measure1],

"Interaction Comfort", [Measure2],

.
.
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Haider_Ali]

Hello,
I have successfully created a table that shows indicators and their values in a table in the report view. I have done this by creating a new table using following DAX query:

MeasureNames3 =

DATATABLE (

    "Measure", STRING,

    {

        {"Detect 1"},

        {"Detect 2"},

        {"Detect 3"}

    })
Detect 1 e.t.c are the measure names.
then I created a new column using following DAX query:

test = SWITCH(MeasureNames3[Measure],

"Detect 1", [Detect 1],

"Detect 2", [Detect 13],

"Detect 3", [Detect 14]

)
These queries have created the desired result. (Screen shot attached) Now the issue is when i apply any filter e.g. select a city or apply date filter using slicer, nothing effects the values of these measures. Is there any way that if I select city or range of date, measure values also change?

[amitchandak]

@VViskaz , You have these you measure name and put them on matric as values and enable show on row. That will do this. You can rename measure a matrix level

Refer :https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

Now values on rows and columns , just measure and show on row

[VViskaz]

But I need to put these measures exactly in a table, not in a visual. I'm planning to build clustered column chart from these. 

I need it to look like this: