Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Raad
New Member

dealing with transactions rows

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")))
 
Raad_0-1710496754749.png

 

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

 

any help are welcome.

thank you 

 

 

1 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

View solution in original post

2 REPLIES 2
Raad
New Member

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))
Raad_0-1710584436744.png

 

Thanks All

 B,R

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.