Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts
I want to amend my current measure to exclude the following codes.
From
=calculate ([quantity],
Filter(Customer Class, Customer Class [Segment] <> "106")
To exclude
1008-0
1011-0
1011-1
1301-1
1301-2
1301-3
1301-4
From Segment column.
Solved! Go to Solution.
Hi @Anonymous ,
You can try modifying your DAX as follows:
CalculationsDax =
CALCULATE ([quantity],
Filter(Customer Class, NOT(Customer Class [Segment]) IN { "1008-0", "1011-0", "1011-1", "1301-1", "1301-2", "1301-3", "1301-4" })
)
Thanks,
Pragati
Hi @Anonymous ,
You can try modifying your DAX as follows:
CalculationsDax =
CALCULATE ([quantity],
Filter(Customer Class, NOT(Customer Class [Segment]) IN { "1008-0", "1011-0", "1011-1", "1301-1", "1301-2", "1301-3", "1301-4" })
)
Thanks,
Pragati
@Anonymous , Try a measure like
calculate ([quantity], Filter('Customer Class', not('Customer Class'[Segment] in {"1008-0" ,"1011-0","1011-1","1301-1","1301-2","1301-3","1301-4" } )))
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |