Power BI "A table of multiple values was supplied where a single value was expected."
12:59 24 Feb 2022

I am trying to leverage a percentage column [percent] to filter the output of the column [throughput]. The DAX query for my measure returns:

A table of multiple values was supplied where a single value was expected.

The query looks like:

Measure = CALCULATE(FIRSTNONBLANKVALUE('table'[throughput],FILTER(ALL('table'[percent]),'table'[percent] > 0.94 && 'table'[percent] < 0.96)))

What am I missing?

excel powerbi dax