Forum Discussion
Using measure as a filter
I apologize for the confusion. When you add a measure to the visual filters pane and select it, you should see a list of filter options displayed below the measure name. These options will vary depending on the type of data that the measure is returning.
For example, if the measure is returning a numeric value, you might see options such as "Greater than or equal to" or "Less than or equal to". If the measure is returning a text value, you might see options such as "Contains" or "Does not contain".
If you are unable to select these options or enter a value, it could be that the measure is not returning the expected data type. For example, if the measure is returning a text value, but the filter options are expecting a numeric value, the options will not be selectable.
To resolve this issue, you can try changing the data type of the measure by using the DAX function CONVERT, or by using the Format property in the Modeling tab of the Power BI ribbon.
I hope this helps!
Thanks for the response... Yes, I understand the steps needed, but your step 4 is where I get hung up. The visual filter drop down options are not selectable nor am I able to enter a selection criteria. The items circled in red in original post are not selectable/actionable.
