Variable Table with a range filter

[Bene]

Hi,

i try to create a variable table with a range of items by totalorder measure.

But it doesn't seem to work.

it doesn't seem to work

VAR Artbetween50_100 =
FILTER(all(table[CodArt]); [TotalOrder]>=50 || [TotalOrder]<100 )

Thank you

[V-lianl-msft · Accepted solution]

Hi @Bene ,

You can use these expressions to make the table as a variable.

CALCULATETABLE; SUMMARIZE; SUMMARIZECOLUMNS; SELECTCOLUMNS; ADDCOLUMNS.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try like

calculatetable(table,FILTER(all(table[CodArt]); [TotalOrder]>=50 || [TotalOrder]<100 ))

[Mariusz]

Hi @Bene 

Please can you provide a data sample and an explanation of what you are trying to achieve?

Also please can you post entire Measure?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn