Trying to create a filter using a new column

[Johannes_Swarts]

Hi All,

Screenshot of data I'm working with:

I'm trying to create a filter to enable filtering of "uninteresting" data - either the sparkline is flat, or the max/min points along the line are within a tolerance of 5%.  So, I can create a measure that returns the filter options I want - "flat", "within tolerance", "outside tolerance" - see column labeled "test_z".  Unfortunately, Power BI does not allow using a measure as a filter.  I then created a new column ("line_filter") with a similar calculation to the one in the measure, but you can see the DAX statement always returns "outside tolerance".

DAX statement in measure "test_z":

test_z = if(trend_checker_vw[POI_count_max] = trend_checker_vw[POI_count_min], "flat",

if (((trend_checker_vw[POI_count_max] - trend_checker_vw[POI_count_min])/trend_checker_vw[POI_count_min]) <= 0.05, "within tolerance", "outside tolerance"

)

)

DAX statement in column "line_filter":

line_filter = if ( max(trend_checker_vw[count]) = min(trend_checker_vw[count]), "flat",

if ((max(trend_checker_vw[count]) - min(trend_checker_vw[count]))/min(trend_checker_vw[count]) <= 0.05,"within tolerance", "outside tolerance")

)

What am I doing wrong?

Thanks in advance,

Hans

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...