Hello @MAAbdullah47, please be reminded that while we encourage everyoneās participation in the forum, we request members to refrain from single calling out of a member to answer a question as this may discourage other users to help your inquiry.
Hi @MAAbdullah47 - In Power BI there is a feature called Performance Analyzer. As this is a basic formula, my suggestion will be to write the required statement using different expressions as you wish and test the performance.
Iām not very good at explaining why it has better performancesā¦
As @ankit said, I also use Personal Analyzer and Dax Studio to analyze my measure performances.
In the case of your measure, I saw that the Inv Total measure had a virtual table in it and I made a guess that filtering the virtual table at the source will be more performant.
I hope it will still help you and I apologize not to be able to give you more details.
My advice is if youāre interesting in looking at the performances of your report, find information on Performance Analyzer and above all Dax Studio