dealing with transactions rows

[Raad]

Hi PBI community

i am new to pbi coding  and try to find best way to deal with transations that have been added to budget.

so i am trying  to show all transactions except for those have ( deffrent Dept and same RefID , which these transaction move cash between them ).

i am try to do it in a measure.

Added fund = CALCULATE(COUNTROWS(T),FILTER(ALLEXCEPT(T, T[RefID]),if(COUNT(T[RefID])=1 && count(T[DeptNo]) = 1,"True","False")))

i want to show all excpet for those rows with yallow mark.

any help are welcome.

thank you 

[Raad]

Hi PBI community

i have found the solation but idk if it the best code.

i just want to share it if any one need it ,  just to filter the table with (isnot 2)

AF4 = CALCULATE(DISTINCTCOUNT(T[DeptNo]),FILTER(ALLEXCEPT(T, T[RefID]),1))

Thanks All

 B,R

[v-weiyan1-msft · Accepted solution]

Hi @Raad ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
If you have any more questions or need further assistance with Power BI, please feel free to ask questions in the forums and our support team will be there.

Best Regards,
Yulia Yan