Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
3 years ago
Solved

Using measure as a filter

Hello, I am wanting to use a measure inside a visual filter - and have seen referenced numerous times.   Below is my measure - returning either a 0 or 1.  The measure works as expected when viewed ...
  • MatthRichardsUK's avatar
    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!