Forum Discussion
Using measure as a filter
- 3 years ago
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!
Dellis81 hey can you let me know how you were able to open the dropdown "is less than"
Hello, your filter measure can be added on the visual filter pane. Otherwise in case of column, you have the possibilty to choose in filter pane, advanced filtering, there you'll find it