Filtering rows by option set item

[mislavraguz]

I'm stuck with kinda banal issue while creating PBI report. I'm using account hierarchy with several levels. Each level has one option set item value. For example, Level 1 has value "A", Level 2 has value "B", etc. I'd like to create column which shows only records with selected value A and I'm struggling to get it.

[Anonymous · Accepted solution]

Hi @mislavraguz ,

The value of a calculated column is computed during data refresh and is stored in the model. Its value will not change with user interaction (filter, slicer selection, etc.). As @amitchandak suggested, you can create a measure. A measure operates on aggregations of data defined by the current context, which depends on the filters applied in the report. You can check the following blog to know more information about calculated column and measure.

Calculated Columns and Measures in DAX

Using the SELECTEDVALUE function in DAX

SELECTEDVALUE

Best Regards

[amitchandak]

@mislavraguz , selectedvalue means value from slicer. You can not create a new column from selected value from slicer

[mislavraguz]

So, if I udnerstood you well, you cannot create a column for records with only certain option set item?