Error with True/false expression used as a table filter expression

[AnthonyPen]

Hello,

I ge the following error: A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Can someone help me with measure:

# Products for 70% Threashold = CALCULATE([count all data var to reach tar],'Data#2'[Cumulated no. Of repl.]<=[Pareto 70% # of Replenishments])

[MEEnergy]

Need more info on what you are trying to get and the data but try this

# Products for 70% Threashold =
CALCULATE([count all data var to reach tar], FILTER(ALL(Data#2),[Cumulated no. Of repl.]<=[Pareto 70% # of Replenishments]))

[AnthonyPen]

Hi,

Thx for that, however, this DAX expressions gvies the wrong results.

I'll elaborat on what i'm trying to do:

- The measure [Pareto 70% # of Replenishments] store a numeric value

- I want to comare that numeric value and count all the lines of data that are less than that value. I'll use the measure [# Products for 70% Threashold] to store that value

- My data is coming from a simple Excel file

Thanks in adavnce for the insight