I have Delivery table that consist of delivery site call sign (DEL_SITE col 1) and receipt site call sign (REC_SITE col2) columns where i need to filter few records which are not in delivery site call sign and which are in receipt site call sign and call that as ex-gretna.
Ex-Gretna Volumes = REC_SITE in (EP, YP, QU, KB, GF) and DEL_SITE NOT in (EP, YP, QU, KB, GF)
and i need to use that ex-gretna as slicer selection for the user.
how can i show this logic using dax?
any help will be appreciated.