Select
Filter (
[Time]. [yqmd]. [quarter]. Members,
[Measures]. [unit sales] & gt; 750
) * [Measures]. [unit sales] On 0
, {[Customer]. [Customer]. [AZ], [Customer]. [Customer]. [Nm],
[Customer]. [Customer]. [ut]} on 1
From [sales]
Q: What filter conditions [measures]. [unit sales]> 750 have been specified. Why are there so many data smaller than 750 returned? See the following query statements:
Select
Filter (
[Time]. [yqmd]. [quarter]. Members,
[Measures]. [unit sales] & gt; 750
) * [Measures]. [unit sales] On 0
, [Customer]. [Customer]. members on 1
From [sales]
Check that every unit sales in the first row of the first column meets the filter conditions.
Filter (
[Time]. [yqmd]. [quarter]. Members,
[Measures]. [unit sales] & gt; 750
)
The filter statement Syntax: returns all quarters with sales exceeding 750. Calculate the filter function to obtain a set that meets the condition, and then split the unit value with axis (1.
This is related to the resolution sequence:
From (evaluate) -- "where with set (or aggregate function) --" axis (evaluate, each axis) -- "result cell (obtain unit value)