FILTER ( set, search_condition )
The set through which to iterate.
A Boolean expression. The search condition is evaluated in the context of every tuple in the set.
select
{ ([measure].[sales amount]) } on 0,
filter({ ([Calendar].[ALL].[2020].[Q1]), ([Calendar].[ALL].[2020]) }, ([measure].[sales amount]) > 29.999 ) on 1
from [Online Store]
where ([Store Type].[ALL].[Platform Self-operated Store],[Payment Method].[ALL].[Credit Card],[Goods].[ALL].[Kitchen & Dining].[Bento Boxes]);
| sales amount | |
| Q1 | 30 |
| 2020 | 60060 |