Forum Discussion
Filtering rows by option set item
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.
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
Best Regards
3 Replies
mislavraguz , selectedvalue means value from slicer. You can not create a new column from selected value from slicer
So, if I udnerstood you well, you cannot create a column for records with only certain option set item?
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
Best Regards
