Forum Discussion

VViskaz's avatar
VViskaz
Regular Visitor
6 years ago
Solved

Entering measures in column

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 mea...
Need Help
Show and Tell
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    6 years ago

    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
Fowmy's avatar
Fowmy
Super User
6 years ago

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's avatar
    Haider_Ali
    Regular Visitor
    2 years ago

    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?