Forum Discussion

Raad's avatar
Raad
New Member
2 years ago
Solved

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")))
 

 

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

 

any help are welcome.

thank you 

 

 

Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    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

2 Replies

  • Raad's avatar
    Raad
    New Member
    2 years ago

    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's avatar
      v-weiyan1-msft
      Community Support
      2 years ago

      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