Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have numerous calculated measures for instance "If(Account_Type_Description = ('Demand Deposit'),(Count(distinct{<DDA_External_Tran_Code={'5'}>}DDA_Description_Link)), (Count(distinct{<SAV_External_Tran_Code={'125'}>}SAV_Description_Link)))". The problem is if I filter on DDA_External_Tran_Code say value "9" I'm still getting the count for value "5" in the measure. I have similar issues throughout the app. How do I fix it? If I select "9" I want this calculation to be "0". Please help.
Try this:
If(Account_Type_Description = ('Demand Deposit'), Count(DISTINCT {<DDA_External_Tran_Code *= {'5'}>} DDA_Description_Link), Count(DISTINCT {<SAV_External_Tran_Code *= {'125'}>} SAV_Description_Link))
Try this:
If(Account_Type_Description = ('Demand Deposit'), Count(DISTINCT {<DDA_External_Tran_Code *= {'5'}>} DDA_Description_Link), Count(DISTINCT {<SAV_External_Tran_Code *= {'125'}>} SAV_Description_Link))
Thanks! It appears that worked! Again thanks so much!