Is it possible to refer to a column in a measure without aggregating?

[Anonymous]

Basically in a visual you can add either a measure or a column.

I'm trying to add a measure that will dynamically change depeding on slicer filters.

What this would look like is:

IF(Selectedvalue)=1;TableXColunmX;If(selectedValue)=2;TableX;ColumnY))

So I would get the same as dragging a column in a visual, but is this possible? Right now If I try to add a column I'm forced to aggregate one way or another, I have managed to create something like this with Calculate(firstnonblank(TableXColumnX;True)) however this is very and I mean very slow, while just adding a column to the visual doesn't even take a second for it to load.

Any help is appreciated.

[amitchandak]

@Anonymous , This is the good example of changing measure using slicer

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

[Greg_Deckler · Accepted solution]

Going to depend, but generally you do something like:

Measure to Show =

  SWITCH(SELECTEDVALUE('Table'[Column]),

    1,[Measure 1],

    2,[Measure 2],

    3,[Measure 3],

    [Measure 4]

  )

If that is not specific enough, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

I had tried something similar and thought it wasn't working correctly.

Seems I was working with too much data for it to work properly, once I limited my data a bit it worked.