Forum Discussion

Bene's avatar
Bene
Frequent Visitor
6 years ago
Solved

Variable Table with a range filter

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

Need Help

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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

     

     

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try like

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