Forum Discussion

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]); [To...

Need Help

V-lianl-msft
6 years ago
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.

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

Forum Discussion

Variable Table with a range filter

Related content

Creating a dynamic filtered table variable

Filtered table

Filter table based on variable table column

Variable still filtered in visual where using REMOVEFILTERS

Can I filter the 1st fact table which then filters a 2nd fact table?