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 ( deffre...
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

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