Create a calculated field with below formula and it can be used in filter
IF (not(ISNULL([A]))AND not(ISNULL([B]))AND not(ISNULL([C]))AND not(ISNULL([D]))) Then 'Exclude Null' Else 'Include Null' END
Write a calculation as
if ISNULL([A]) or ISNULL([B]) or ISNULL([C]) or ISNULL([D])
then 'True' else 'False' END
Drag this into filter and select false.
Now we will get bed and desk non nulls.
BI, Aspire Systems (India) Pvt Ltd
A - D come under the dimension - customer name, how do I write that into the formula?
You could be using a LOD expression (either FIXED or EXCLUDE one)
to filter only those Products sold to maximum number of Customers.
Please find the attached as an example.
Hope it could help a bit.
Filter_LOD_v10.2_YF.twbx 24.5 KB