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!
It sounds like you want to use the CostCalculatorHOVFilter measure as a visual filter in a Power BI report.
To use a measure as a visual filter in Power BI, you need to do the following:
- Create the measure using a DAX formula, as you have done.
- Add the measure to the visual filters pane for the visual that you want to filter.
- Select the measure from the list of available filters in the visual filters pane.
- Set the filter criteria for the measure using the options provided in the visual filters pane.
Once you have done these steps, the visual will be filtered based on the criteria that you set for the measure.
If you are unable to see the measure in the list of available filters in the visual filters pane, make sure that the measure is being displayed in the Fields pane for the table or matrix that the visual is based on. If the measure is not listed in the Fields pane, you can add it by right-clicking on the table or matrix and selecting "Add Measure".
I hope this helps! Let me know if you have any questions.
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.
