Forum Discussion
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...
Fowmy
Super User
Super User
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:
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?
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?