Forum Discussion
Solved
Error in filter formula
Hi, I have sample data of a superstore and I want to filter orders which have quantity>5, I tried to do a formula like this Measure = FILTER(Orders; Orders[Quantity]>5) but I have this error: T...
Giada_Togliatti , Create a measure like this. Use it in card visual or with order number/ID on other visuals
calculate(countrows(Orders), FILTER(Orders; Orders[Quantity]>5))
Filter return table not a value
Giada_Togliatti , Create a measure like this. Use it in card visual or with order number/ID on other visuals
calculate(countrows(Orders), FILTER(Orders; Orders[Quantity]>5))
Filter return table not a value