Measures in a table by row level

[jothi_prakash_a]

I have the following measures.

FlagCount, AvgVal, Decile

And I want these measures in like a table format in row level.

Something like this.

ColumnName	Measures
Column1	FlagCount
Column2	AvgVal
Column3	Decile

The above table will be used in a bar chart and the dashboard has slicers. how can I achieve this?

Thank you!

[sturlaws · Accepted solution]

Hi @jothi_prakash_a,

you can create a separate table, with the measure names on the rows.

Create a new measure like this:

MainMeasure = 
VAR _measure =
    CALCULATE ( SELECTEDVALUE ( MeasuresTable[Measures] ) )
RETURN
    SWITCH (
        TRUE (),
        _measure = "Measure1", [Measure1],
        _measure = "Measure2", [Measure2],
        _measure = "Measure3", [Measure3]
    )

An example 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.