Forum Discussion
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 measures in.
4 Replies
- Fowmy
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: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
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:
