cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyPen Frequent Visitor
Frequent Visitor

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

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])

 

 

 

2 REPLIES 2
Highlighted
MEEnergy Frequent Visitor
Frequent Visitor

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

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 Frequent Visitor
Frequent Visitor

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

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