Forum Discussion

sjoshi's avatar
sjoshi
Helper II
7 years ago

IF, FILTER SUM Function

Hello,   I'm trying to do one simple thing but not sure why filter is not working   If accountnum ="14850" the take sum of amount for accountnum "52500" else null. This statement I have tried to ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this measure

 

52500 = IF(HASONEVALUE('LedgerTrans Fact'[AccountNum]),IF(VALUES('LedgerTrans Fact'[AccountNum])="14850",CALCULATE(SUM('LedgerTrans Fact'[AmountMST]),'LedgerTrans Fact'[AccountNum]="52500"),0),BLANK())

 

Hope this helps.

sjoshi's avatar
sjoshi
Helper II
7 years ago

 Hi Ashish

 

I have tried to create measure in above way but ots returing always 0 value. Also I have created column with Greg's solution which is by adding all but both did not work and in values are 0 for 52500 column

 

Thanks

Smita