Matrix several Measures in one column

[AltusTellus]

Hi all,

I have a problem with creating a view in a matrix table. First some extra information:

One table with KPI's with different measures like [EmployCostsvsRevenue] and [ResultsvsRevenue]:

EmployCostsvsRevenue = SUMX(FILTER('KPI Description';'KPI Description'[RefCode]=2); [EmployeeCosts] / [AmountRevenue] *-1)

ResultsvsRevenue = SUMX(FILTER('KPI Description';'KPI Description'[RefCode]=1); [AmountResult] / [AmountRevenue])

The outcome is okay, but I want to create one column with the different values among each other, filtered by the KPI description Ratio. Like one column named [Value] e.g.

I think I need to create one "big" measure so that I have one column, but I don't know how to build this. Please help, thnx for your support!

[amitchandak]

@AltusTellus , are the column values are categorical ?

Or you looking for slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[Mariusz · Accepted solution]

HI @AltusTellus 

Try the COALESCE function if the values will show next to the right description by default.

https://docs.microsoft.com/en-us/dax/coalesce-function-dax

Otherwise, you can use SWITCH with 

Measure 2 = 
SWITCH(
    SELECTEDVALUE( 'Table'[Descriptions] ),
    "description 1", [EmployCostsvsRevenue] 
    "description 2", [ResultsvsRevenue],
    [Measure]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[AltusTellus]

Hi Mariusz,

Thnx (!) for your solution, the next is working!

Measure_2 =

SWITCH(SELECTEDVALUE('KPI'[Description]);

"Pers. Kst. / Omzet"; [EmployCostsvsRevenue];

"Resultaat / Omzet"; [ResultsvsRevenue]

)

Note: where 'KPI'[Description] = table with descriptions and the different KPI's (measures).

[MFelix]

Hi @AltusTellus ,

On the matrix option search the option values show on rows turn it on and the measure will be placed on rows instead of columns.